ACC2: List of Constants in Macros and Modules

Last reviewed: June 8, 1997
Article ID: Q112140
The information in this article applies to:
  • Microsoft Access version 2.0

SUMMARY

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

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 : kbprg MdlLib
Version : 2.0
Platform : WINDOWS
Hardware : X86
Issue type : kbinfo


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: June 8, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.