ID: Q140214
The information in this article applies to:
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.
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
For more information about constants, search for "constants" using the Microsoft Access for Windows 95 Help Index.
Keywords : kbprg MdlLib
Version : 7.0
Platform : WINDOWS
Hardware : x86
Issue type : kbinfoLast Reviewed: August 29, 1997