Article ID: 140214
Article Last Modified on 10/11/2006
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
Keywords: kbinfo kbprogramming KB140214