ACC2: List of Constants in Macros and Modules

ID: Q112140


The information in this article applies to:


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 
Issue type        : kbinfo 

Last Reviewed: April 3, 1999