Microsoft KB Archive/112140

= ACC2: List of Constants in Macros and Modules =

Article ID: 112140

Article Last Modified on 7/8/2002

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q112140



Moderate: Requires basic macro, coding, and interoperability skills.



SUMMARY
This article lists the constant variables that are in the UTILITY.MDA file. This list is for reference only; importing these constants would result in a duplicate definition error.

Microsoft Access directory. This text file is provided for supplementary use and can be imported.



MORE INFORMATION
AbcConstants Module from UTILITY.MDA:

 NOTE: All of the constants listed below are global constants.

V_EMPTY = 0               V_NULL = 1                 V_INTEGER = 2 V_LONG = 3                V_SINGLE = 4               V_DOUBLE = 5 V_CURRENCY = 6            V_DATE = 7                 V_STRING = 8 DB_BINARY = 9             DB_OLE = 11                DB_NONULLS = 3 A_TABLE = 0               A_QUERY = 1                A_FORM = 2 A_REPORT = 3              A_MACRO = 4                A_MODULE = 5 A_FORMBAR = 0             A_FILE = 0                 A_EDITMENU = 1 A_RECORDSMENU = 3         A_NEW = 0                  A_SAVEFORM = 2 A_SAVEFORMAS = 3          A_SAVERECORD = 4           A_UNDO = 0 A_UNDOFIELD = 1           A_CUT = 2                  A_COPY = 3 A_PASTE = 4               A_DELETE = 6               A_SELECTRECORD = 7 A_SELECTALLRECORDS = 8    A_OBJECT = 14              A_REFRESH = 2 A_OBJECTVERB = 0          A_OBJECTUPDATE = 3         A_ANYWHERE = 0 A_ENTIRE = 1              A_START = 2                A_UP = 0 A_DOWN = 1                A_CURRENT = 0              A_ALL = 1 A_PREVIOUS = 0            A_NEXT = 1                 A_FIRST = 2 A_LAST = 3                A_GOTO = 4                 A_NEWREC = 5 A_NORMAL = 0              A_DESIGN = 1               A_PREVIEW = 2 A_FORMDS = 3              A_ADD = 0                  A_EDIT = 1 A_READONLY = 2            A_HIDDEN = 1               A_ICON = 2 A_DIALOG = 3              A_PRINTALL = 0             A_SELECTION = 1 A_PAGES = 2               A_HIGH = 0                 A_MEDIUM = 1 A_LOW = 2                 A_DRAFT = 3                A_PROMPT = 0 A_SAVE = 1                A_EXIT = 2                 A_IMPORT = 0 A_EXPORT = 1              A_ATTACH = 2               A_IMPORTDELIM = 0 A_IMPORTFIXED = 1         A_EXPORTDELIM = 2          A_EXPORTFIXED = 3 A_EXPORTMERGE = 4         OLE_CHANGED = 0            OLE_SAVED = 1 OLE_CLOSED = 2            OLE_RENAMED = 3            OLE_RELEASE = 5 SHIFT_MASK = 1            CTRL_MASK = 2              ALT_MASK = 4 LEFT_BUTTON = 1           RIGHT_BUTTON = 2           MIDDLE_BUTTON = 4 DATA_ERRCONTINUE = 0      DATA_ERRDISPLAY = 1        DATA_ERRADDED = 2 LB_INITIALIZE = 0         LB_OPEN = 1                LB_GETROWCOUNT = 3 LB_GETCOLUMNCOUNT = 4     LB_GETCOLUMNWIDTH = 5      LB_GETVALUE = 6 LB_GETFORMAT = 7          LB_CLOSE = 8               LB_END = 9 SYSCMD_INITMETER = 1      SYSCMD_UPDATEMETER = 2    SYSCMD_REMOVEMETER = 3 SYSCMD_SETSTATUS = 4      SYSCMD_CLEARSTATUS = 5     SYSCMD_RUNTIME = 6 SYSCMD_ACCESSVER = 7      SYSCMD_CLEARHELPTOPIC = 11 OBJSTATE_OPEN = 1 OBJSTATE_NEW = 4          OBJSTATE_DIRTY = 2         A_DELETE_V2 = 7 A_SELECTRECORD_V2 = 8     A_SELECTALLRECORDS_V2 = 9  A_TOOLBAR_YES = 0 A_TOOLBAR_WHERE_APPROP = 1 A_TOOLBAR_NO = 2          DELETE_OK = 0 DELETE_CANCEL = 1         DELETE_USER_CANCEL = 2

Form, Report, Macro and Module Specific Security Constants:

 DB_SEC_FRMRPT_READDEF = &H4& DB_SEC_FRMRPT_WRITEDEF = &H8& + DB_SEC_FRMRPT_READDEF + DB_SEC_DELETE DB_SEC_FRMRPT_EXECUTE = &H100& DB_SEC_MAC_READDEF = &HA& DB_SEC_MAC_WRITEDEF = &H6& + DB_SEC_DELETE DB_SEC_MAC_EXECUTE = &H8& DB_SEC_MOD_READDEF = &H2& DB_SEC_MOD_WRITEDEF = &H4& + DB_SEC_MOD_READDEF + DB_SEC_DELETE A_MENU_VER1X = 11, A_MENU_VER20 = 20 A_FORMATRTF = "Rich Text Format (*.rtf)" A_FORMATXLS = "Microsoft Excel (*.xls)" A_FORMATTXT = "MS-DOS Text (*.txt)"

DataConstants Module from UTILITY.MDA:

 DB_OPEN_TABLE = 1 DB_OPEN_DYNASET = 2 DB_OPEN_SNAPSHOT = 4 DB_DENYWRITE = &H1 DB_DENYREAD = &H2 DB_READONLY = &H4 DB_APPENDONLY = &H8 DB_INCONSISTENT = &H10 DB_CONSISTENT = &H20 DB_SQLPASSTHROUGH = &H40 DB_FAILONERROR = &H80 DB_FORWARDONLY = &H100 DB_OPTIONINIPATH = 1 DB_FIXEDFIELD = &H1 DB_VARIABLEFIELD = &H2 DB_AUTOINCRFIELD = &H10 DB_UPDATABLEFIELD = &H20 DB_DESCENDING = &H1 DB_BOOLEAN = 1 DB_BYTE = 2 DB_INTEGER = 3 DB_LONG = 4 DB_CURRENCY = 5 DB_SINGLE = 6 DB_DOUBLE = 7 DB_DATE = 8 DB_TEXT = 10 DB_LONGBINARY = 11 DB_MEMO = 12 DB_RELATIONUNIQUE = &H1& DB_RELATIONDONTENFORCE = &H2& DB_RELATIONINHERITED = &H4& DB_RELATIONUPDATECASCADE = &H100& DB_RELATIONDELETECASCADE = &H1000& DB_RELATIONLEFT = &H1000000 DB_RELATIONRIGHT = &H2000000 DB_ATTACHEXCLUSIVE = &H10000 DB_ATTACHSAVEPWD = &H20000 DB_SYSTEMOBJECT = &H80000002 DB_ATTACHEDTABLE = &H40000000 DB_ATTACHEDODBC = &H20000000 DB_HIDDENOBJECT = &H1& DB_TABLE = 1 DB_QUERYDEF = 5 DB_QSELECT = &H0 DB_QACTION = &HF0 DB_QCROSSTAB = &H10 DB_QDELETE = &H20 DB_QUPDATE = &H30 DB_QAPPEND = &H40 DB_QMAKETABLE = &H50 DB_QDDL = &H60 DB_QSQLPASSTHROUGH = &H70 DB_QSETOPERATION = &H80 DB_QSPTBULK = &H90 DB_UNIQUE = 1 DB_PRIMARY = 2 DB_PROHIBITNULL = 4 DB_IGNORENULL = 8 DB_LANG_ARABIC = ";LANGID=0x0401;CP=1256;COUNTRY=0" DB_LANG_CZECH = ";LANGID=0x0405;CP=1250;COUNTRY=0" DB_LANG_DUTCH = ";LANGID=0x0413;CP=1252;COUNTRY=0" DB_LANG_GENERAL = ";LANGID=0x0409;CP=1252;COUNTRY=0" DB_LANG_GREEK = ";LANGID=0x0408;CP=1253;COUNTRY=0" DB_LANG_HEBREW = ";LANGID=0x040D;CP=1255;COUNTRY=0" DB_LANG_HUNGARIAN = ";LANGID=0x040E;CP=1250;COUNTRY=0" DB_LANG_ICELANDIC = ";LANGID=0x040F;CP=1252;COUNTRY=0" DB_LANG_NORDIC = ";LANGID=0x041D;CP=1252;COUNTRY=0" DB_LANG_NORWDAN = ";LANGID=0x0414;CP=1252;COUNTRY=0" DB_LANG_POLISH = ";LANGID=0x0415;CP=1250;COUNTRY=0" DB_LANG_CYRILLIC = ";LANGID=0x0419;CP=1251;COUNTRY=0" DB_LANG_SPANISH = ";LANGID=0x040A;CP=1252;COUNTRY=0" DB_LANG_SWEDFIN = ";LANGID=0x040B;CP=1252;COUNTRY=0" DB_LANG_TURKISH = ";LANGID=0x041F;CP=1254;COUNTRY=0" DB_VERSION10 = 1 DB_ENCRYPT = 2 DB_DECRYPT = 4 DB_VERSION11 = 8 DB_VERSION20 = 16 DB_SORTARABIC = 267 DB_SORTCYRILLIC = 263 DB_SORTCZECH = 264 DB_SORTDUTCH = 259 DB_SORTGENERAL = 256 DB_SORTGREEK = 269 DB_SORTHEBREW = 268 DB_SORTHUNGARIAN = 265 DB_SORTICELANDIC = 262 DB_SORTNORWDAN = 261 DB_SORTPDXINTL = 4096 DB_SORTPDXNOR = 4098 DB_SORTPDXSWE = 4097 DB_SORTPOLISH = 266 DB_SORTSPANISH = 258 DB_SORTSWEDFIN = 260 DB_SORTTURKISH = 270 DB_SORTUNDEFINED = -1 DB_FREELOCKS = 1 DB_SEC_NOACCESS = &H0& DB_SEC_FULLACCESS = &HFFFFF DB_SEC_DELETE = &H10000 DB_SEC_READSEC = &H20000 DB_SEC_WRITESEC = &H40000 DB_SEC_WRITEOWNER = &H80000 DB_SEC_DBCREATE = &H1& DB_SEC_DBOPEN = &H2& DB_SEC_DBEXCLUSIVE = &H4& DB_SEC_CREATE = &H1& DB_SEC_READDEF = &H4& DB_SEC_WRITEDEF = &H8& Or DB_SEC_READDEF Or DB_SEC_DELETE DB_SEC_RETRIEVEDATA = &H10& Or DB_SEC_READDEF DB_SEC_INSERTDATA = &H20& DB_SEC_REPLACEDATA = &H40& DB_SEC_DELETEDATA = &H80&

