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&
REFERENCES
For more information about constants, search for "constants," and then "Constants" using the Microsoft Access Help menu.
Keywords: kbinfo kbprogramming KB112140
