ACC95: Constants in the Microsoft Access 95 Object Library

Last reviewed: August 28, 1997
Article ID: Q140214
The information in this article applies to:
  • Microsoft Access version 7.0

SUMMARY

This article lists the constant variables that are in the Microsoft Access for Windows 95 version 7.0 object library. The discrepancy in values for some of these constants is a result of differences in the menu organization between versions. You should not mix version 7.0 constants and constants from earlier versions of Microsoft Access in the same DoMenuItem statement.

MORE INFORMATION

A listing of all the available constants in the Microsoft Access 7.0 object library is available by using the Object Browser. To use the Object Browser, open a module in Design view, press F2, and select "Access - Microsoft Access for Windows 95" in the Libraries/Database box. Then, select "Constants" in the Modules/Classes box.

NOTE: In Microsoft Access 97, you can easily display a list of all the available constants by typing CTRL+J while in Design view of a module. You can also display the list of available constants by pressing F2 while in Design view of any module to bring up the Object Browser. Then, click Access or another library in the Project/Library box and select the class you want information on in the Classes box. If you would like to see a list of all members that can be assessed globally, click <Globals> in the Classes box.

MS Access 7.0            Value     MS Access 2.0            Value
-------------            -----     -------------            -----
                                     A_SELECTALLRECORDS        8
                                     A_UNDOFIELD               1
                                     A_DELETE_V2               7
acAdd                       0        A_ADD                     0
acAll                       1        A_ALL                     1
acAltMask                   4        ALT_MASK                  4
acAnyWhere                  0        A_ANYWHERE                0
acApplyFilter               1
acBoundObjectFrame        108
acCheckBox                106
acCloseFilterWindow         2
acComboBox                111
acCommandButton           104
acCopy                      2        A_COPY                    3
acCtrlMask                  2        CTRL_MASK                 2
acCurrent                   0        A_CURRENT                 0
acCustomControl           119
acCut                       1        A_CUT                     2
acDataErrAdded              2        DATA_ERRADDED             2
acDataErrContinue           0        DATA_ERRCONTINUE          0
acDataErrDisplay            1        DATA_ERRDISPLAY           1
acDelete                    6        A_DELETE                  6
acDeleteCancel              1        DELETE_CANCEL             1
acDeleteOK                  0        DELETE_OK                 0
acDeleteUserCancel          2        DELETE_USER_CANCEL        2
acDesign                    1        A_DESIGN                  1
acDetail                    0
acDialog                    3        A_DIALOG                  3
acDown                      1        A_DOWN                    1
acDraft                     3        A_DRAFT                   3
acEdit                      1        A_EDIT                    1
acEditMenu                  1        A_EDITMENU                1
acEffectChisel              5
acEffectEtched              3
acEffectNormal              0
acEffectRaised              1
acEffectShadow              4
acEffectSunken              2
acEntire                    1        A_ENTIRE                  1
acExit                      2        A_EXIT                    2
acExport                    1        A_EXPORT                  1
acExportDelim               2        A_EXPORTDELIM             2
acExportFixed               3        A_EXPORTFIXED             3
acExportMerge               4        A_EXPORTMERGE             4
acFile                      0        A_FILE                    0
acFilterAdvanced            1
acFilterByForm              0
acFirst                     2        A_FIRST                   2
acFooter                    2
acForm                      2        A_FORM                    2
acFormBar                   0        A_FORMBAR                 0
acFormDS                    3        A_FORMDS                  3
acGoTo                      4        A_GOTO                    4
acGridlinesBoth             3
acGridlinesBothV2           1
acGridlinesHoriz            1
acGridlinesNone             0
acGridlinesVert             2
acGroupLevel1Footer         6
acGroupLevel1Header         5
acGroupLevel2Footer         8
acGroupLevel2Header         7
acHeader                    1
acHidden                    1        A_HIDDEN                  1
acHigh                      0        A_HIGH                    0
acIcon                      2        A_ICON                    2
acImage                   103
acImport                    0        A_IMPORT                  0
acImportDelim               0        A_IMPORTDELIM             0
acImportFixed               1        A_IMPORTFIXED             1
acLabel                   100
acLast                      3        A_LAST                    3
acLBClose                   8        LB_CLOSE                  8
acLBEnd                     9        LB_END                    9
acLBGetColumnCount          4        LB_GETCOLUMNCOUNT         4
acLBGetColumnWidth          5        LB_GETCOLUMNWIDTH         5
acLBGetFormat               7        LB_GETFORMAT              7
acLBGetRowCount             3        LB_GETROWCOUNT            3
acLBGetValue                6        LB_GETVALUE               6
acLBInitialize              0        LB_INITIALIZE             0
acLBOpen                    1        LB_OPEN                   1
acLeftButton                1        LEFT_BUTTON               1
acLine                    102
acLink                      2        A_ATTACH                  2
acLinkDelim                 5
acLinkFixed                 6
acListBox                 110
acLow                       2        A_LOW                     2
acMacro                     4        A_MACRO                   4
acMedium                    1        A_MEDIUM                  1
acMenuCheck                 3
acMenuGray                  1
acMenuUncheck               2
acMenuUngray                0
acMenuVer1X                11        A_MENU_VER1X             11
acMenuVer20                20        A_MENU_VER20             20
acMenuVer70                70
acMiddleButton              4        MIDDLE_BUTTON             4
acModule                    5        A_MODULE                  5
acNew                       0        A_NEW                     0
acNewRec                    5        A_NEWREC                  5
acNext                      1        A_NEXT                    1
acNormal                    0        A_NORMAL                  0
acObject                   14        A_OBJECT                 14
acObjectFrame             114
acObjectUpdate              3        A_OBJECTUPDATE            3
acObjectVerb                0        A_OBJECTVERB              0
acObjStateDirty             2        OBJSTATE_DIRTY            2
acObjStateNew               4        OBJSTATE_NEW              4
acObjStateOpen              1        OBJSTATE_OPEN             1
acOLEActivate               7        OLE_ACTIVATE              7
acOLEActivateDoubleClick    2        OLE_ACTIVATE_DOUBLECLICK  2
acOLEActivateGetFocus       1        OLE_ACTIVATE_GETFOCUS     1
acOLEActivateManual         0        OLE_ACTIVATE_MANUAL       0
acOleChanged                0        OLE_CHANGED               0
acOLEClose                  9        OLE_CLOSE                 9
acOleClosed                 2        OLE_CLOSED                2
acOLECopy                   4        OLE_COPY                  4
acOLECreateEmbed            0        OLE_CREATE_EMBED          0
acOLECreateFromFile         1        OLE_CREATE_FROM_FILE      1
acOLECreateLink             1        OLE_CREATE_LINK           1
acOLECreateNew              0        OLE_CREATE_NEW            0
acOLEDelete                10        OLE_DELETE               10
acOLEDisplayContent         0        OLE_DISPLAY_CONTENT       0
acOLEDisplayIcon            1        OLE_DISPLAY_ICON          1
acOLEEither                 2        OLE_EITHER                2
acOLEEmbedded               1        OLE_EMBEDDED              1
acOLEFetchVerbs            17        OLE_FETCH_VERBS          17
acOLEInsertObjDlg          14        OLE_INSERT_OBJ_DLG       14
acOLELinked                 0        OLE_LINKED                0
acOLENone                   3        OLE_NONE                  3
acOLEPaste                  5        OLE_PASTE                 5
acOLEPasteSpecialDlg       15        OLE_PASTE_SPECIAL_DLG    15
acOleRenamed                3        OLE_RENAMED               3
acOleSaved                  1        OLE_SAVED                 1
acOLESizeAutoSize           2        OLE_SIZE_AUTOSIZE         2
acOLESizeClip               0        OLE_SIZE_CLIP             0
acOLESizeStretch            1        OLE_SIZE_STRETCH          1
acOLESizeZoom               3        OLE_SIZE_ZOOM             3
acOLEUpdate                 6        OLE_UPDATE                6
acOLEUpdateAutomatic        0        OLE_AUTOMATIC             0
acOLEUpdateFrozen           1        OLE_FROZEN                1
acOLEUpdateManual           2        OLE_MANUAL                2
acOLEVerbHide              -3        VERB_HIDE                -3
acOLEVerbInPlaceActivate   -5        VERB_INPLACEACTIVATE     -5
acOLEVerbInPlaceUIActivate -4        VERB_INPLACEUIACTIVATE   -4
acOLEVerbOpen              -2        VERB_OPEN                -2
acOLEVerbPrimary            0        VERB_PRIMARY              0
acOLEVerbShow              -1        VERB_SHOW                -1
acOptionButton            105
acOptionGroup             107
acPageBreak               118
acPageFooter                4
acPageHeader                3
acPages                     2        A_PAGES                   2
acPaste                     3        A_PASTE                   4
acPreview                   2        A_PREVIEW                 2
acPrevious                  0        A_PREVIOUS                0
acPrintAll                  0        A_PRINTALL                0
acPrompt                    0        A_PROMPT                  0
acPropCatData               2        PROP_CAT_DATA             2
acPropCatEvent              4        PROP_CAT_EVENT            4
acPropCatLayout             1        PROP_CAT_LAYOUT           1
acPropCatNA                 0        PROP_CAT_NA               0
acPropCatOther              8        PROP_CAT_OTHER            8
acQuery                     1        A_QUERY                   1
acReadOnly                  2        A_READONLY                2
acRecordsMenu               5        A_RECORDSMENU             3
acRectangle               101
acRefresh                   5        A_REFRESH                 2
acReport                    3        A_REPORT                  3
acRightButton               2        RIGHT_BUTTON              2
acSave                      1        A_SAVE                    1
acSaveForm                  4        A_SAVEFORM                2
acSaveFormAs                5        A_SAVEFORMAS              3
acSaveRecord                4        A_SAVERECORD              4
acSaveYes                   1
acSearchAll                 2
acSecFrmRptExecute        256        DB_SEC_FRMRPT_EXECUTE     &H100&
acSecFrmRptReadDef          4        DB_SEC_FRMRPT_READDEF     &H4&
acSecMacExecute             8        DB_SEC_MAC_EXECUTE        &H8&
acSecMacReadDef            10        DB_SEC_MAC_READDEF        &HA&
acSecModReadDef             2        DB_SEC_MOD_READDEF        &H2&
acSelectAllRecords          9        A_SELECTALLRECORDS_V2     9
acSelection                 1        A_SELECTION               1
acSelectRecord              8        A_SELECTRECORD_V2         8
acSelectRecord              8        A_SELECTRECORD            7
acShiftMask                 1        SHIFT_MASK                1
acShowAllRecords            0
acStart                     2        A_START                   2
acSubForm                 112
acSysCmdAccessDir           9        SYSCMD_ACCESSDIR          9
acSysCmdAccessVer           7        SYSCMD_ACCESSVER          7
acSysCmdClearHelpTopic     11        SYSCMD_CLEARHELPTOPIC    11
acSysCmdClearStatus         5        SYSCMD_CLEARSTATUS        5
acSysCmdGetObjectState     10        SYSCMD_GETOBJECTSTATE    10
acSysCmdGetWorkgroupFile   13
acSysCmdIniFile             0        SYSCMD_INIFILE            8
acSysCmdInitMeter           1        SYSCMD_INITMETER          1
acSysCmdProfile            12
acSysCmdRemoveMeter         3        SYSCMD_REMOVEMETER        3
acSysCmdRuntime             6        SYSCMD_RUNTIME            6
acSysCmdSetStatus           4        SYSCMD_SETSTATUS          4
acSysCmdUpdateMeter         2        SYSCMD_UPDATEMETER        2
acTable                     0        A_TABLE                   0
acTextBox                 109
acToggleButton            122
acToolbarNo                 2        A_TOOLBAR_NO              2
acToolbarWhereApprop        1        A_TOOLBAR_WHERE_APPROP    1
acToolbarYes                0        A_TOOLBAR_YES             0
acUndo                      0        A_UNDO                    0
acUp                        0        A_UP                      0

MS Access 7.0            Value     MS Access 2.0            Value
-------------            -----     -------------            -----
vbKey0                     48
vbKey1                     49
vbKey2                     50
vbKey3                     51
vbKey4                     52
vbKey5                     53
vbKey6                     54
vbKey7                     55
vbKey8                     56
vbKey9                     57
vbKeyA                     65
vbKeyAdd                  107        KEY_ADD                   &H6B
vbKeyB                     66
vbKeyBack                   8        KEY_BACK                  &H8
vbKeyC                     67
vbKeyCancel                 3        KEY_CANCEL                &H3
vbKeyCapital               20        KEY_CAPITAL               &H14
vbKeyClear                 12        KEY_CLEAR                 &HC
vbKeyControl               17        KEY_CONTROL               &H11
vbKeyD                     68
vbKeyDecimal              110        KEY_DECIMAL               &H6E
vbKeyDelete                46        KEY_DELETE                &H2E
vbKeyDivide               111        KEY_DIVIDE                &H6F
vbKeyDown                  40        KEY_DOWN                  &H28
vbKeyE                     69
vbKeyEnd                   35        KEY_END                   &H23
vbKeyEscape                27        KEY_ESCAPE                &H1B
vbKeyExecute               43        KEY_EXECUTE               &H2B
vbKeyF                     70
vbKeyF1                   112        KEY_F1                    &H70
vbKeyF10                  121        KEY_F10                   &H79
vbKeyF11                  122        KEY_F11                   &H7A
vbKeyF12                  123        KEY_F12                   &H7B
vbKeyF13                  124        KEY_F13                   &H7C
vbKeyF14                  125        KEY_F14                   &H7D
vbKeyF15                  126        KEY_F15                   &H7E
vbKeyF16                  127        KEY_F16                   &H7F
vbKeyF2                   113        KEY_F2                    &H71
vbKeyF3                   114        KEY_F3                    &H72
vbKeyF4                   115        KEY_F4                    &H73
vbKeyF5                   116        KEY_F5                    &H74
vbKeyF6                   117        KEY_F6                    &H75
vbKeyF7                   118        KEY_F7                    &H76
vbKeyF8                   119        KEY_F8                    &H77
vbKeyF9                   120        KEY_F9                    &H78
vbKeyG                     71
vbKeyH                     72
vbKeyHelp                  47        KEY_HELP                  &H2F
vbKeyHome                  36        KEY_HOME                  &H24
vbKeyI                     73
vbKeyInsert                45        KEY_INSERT                &H2D
vbKeyJ                     74
vbKeyK                     75
vbKeyL                     76
vbKeyLbutton                1        KEY_LBUTTON               &H1
vbKeyLeft                  37        KEY_LEFT                  &H25
vbKeyM                     77
vbKeyMbutton                4        KEY_MBUTTON               &H4
vbKeyMenu                  18        KEY_MENU                  &H12
vbKeyMultiply             106        KEY_MULTIPLY              &H6A
vbKeyN                     78
vbKeyNext                  34        KEY_NEXT                  &H22
vbKeyNumlock              144        KEY_NUMLOCK               &H90
vbKeyNumpad0               96        KEY_NUMPAD0               &H60
vbKeyNumpad1               97        KEY_NUMPAD1               &H61
vbKeyNumpad2               98        KEY_NUMPAD2               &H62
vbKeyNumpad3               99        KEY_NUMPAD3               &H63
vbKeyNumpad4              100        KEY_NUMPAD4               &H64
vbKeyNumpad5              101        KEY_NUMPAD5               &H65
vbKeyNumpad6              102        KEY_NUMPAD6               &H66
vbKeyNumpad7              103        KEY_NUMPAD7               &H67
vbKeyNumpad8              104        KEY_NUMPAD8               &H68
vbKeyNumpad9              105        KEY_NUMPAD9               &H69
vbKeyO                     79
vbKeyP                     80
vbKeyPause                 19        KEY_PAUSE                 &H13
vbKeyPrint                 42        KEY_PRINT                 &H2A
vbKeyPrior                 33        KEY_PRIOR                 &H21
vbKeyQ                     81
vbKeyR                     82
vbKeyRbutton                2        KEY_RBUTTON               &H2
vbKeyReturn                13        KEY_RETURN                &HD
vbKeyRight                 39        KEY_RIGHT                 &H27
vbKeyS                     83
vbKeySelect                41        KEY_SELECT                &H29
vbKeySeparator            108        KEY_SEPARATOR             &H6C
vbKeyShift                 16        KEY_SHIFT                 &H10
vbKeySnapshot              44        KEY_SNAPSHOT              &H2C
vbKeySpace                 32        KEY_SPACE                 &H20
vbKeySubtract             109        KEY_SUBTRACT              &H6D
vbKeyT                     84
vbKeyTab                    9        KEY_TAB                   &H9
vbKeyU                     85
vbKeyUp                    38        KEY_UP                    &H26
vbKeyV                     86
vbKeyW                     87
vbKeyX                     88
vbKeyY                     89
vbKeyZ                     90

MS Access 7.0               Value
-------------               -----
acFormat                    RTF Rich Text Format (*.rtf)
acFormat                    TXT MS-DOS Text (*.txt)
acFormat                    XLS Microsoft Excel (*.xls)

MS Access 2.0               Value
-------------               -----
A_FORMATRTF                 Rich Text Format (*,rtf)
A_FORMATTXT                 MS-DOS Text (*.txt)
A_FORMATXLS                 Microsoft Excel (*.xls)

MS Access 7.0               Value
-------------               -----
acSecFrmRptWriteDef         65548
acSecMacWriteDef            65542
acSecModWriteDef            65542

MS Access 2.0               Value
-------------               -----
DB_SEC_FRMRPT_WRITEDEF      &H8& + DB_SEC_FRMRPT_READDEF + DB_SEC_DELETE
DB_SEC_MAC_WRITEDEF         &H6& + DB_SEC_DELETE
DB_SEC_MOD_WRITEDEF         &H4& + DB_SEC_MOD_READDEF + DB_SEC_DELETE

REFERENCES

For more information about constants, search for "constants" using the Microsoft Access for Windows 95 Help Index.

Keywords          : kbprg PgmOthr MdlLib
Version           : 7.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: August 28, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.