Microsoft KB Archive/140214

= ACC95: Constants in the Microsoft Access 95 Object Library =

Article ID: 140214

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q140214



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

