Knowledge Base |

# 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&

## REFERENCES

For more information about constants, search for "constants," and then "Constants" using the Microsoft Access Help menu.

Keywords: kbinfo kbprogramming KB112140