Access 2000

With the release of Access 2000, 45 RunCommand constants were added. 38 constants are listed in the Help File. 7 constants are undocumented in the Help system but do appear in the Object browser.

In addition as Access 2000 now uses the Visual Basic Editor, a number of RunCommand constants from Access 97 are retained for backwards compatibilty. These are the ones that covered the Module Design view. The Access 2000 Help File shows these in italics. However it seems to have some ommissions. The ones I have found are listed below.

See the Full List for information on all the constants.

Undocumented Constants

The constants listed below are not in Access 2000 Help but do appear in the Object Browser.

acCmdClearHyperlink
acCmdGroupByTable
acCmdSaveAsDataAccessPage
acCmdDemote
acCmdQueryGroupBy
acCmdConnection
acCmdPromote
Return to top

New in Access 2000

Below is a list of RunCommand constants added in Access 2000.

acCmdDataAccessPageBrowse
acCmdDiagramAutosizeSelectedTables
acCmdDiagramLayoutSelection
acCmdDiagramNewTable
acCmdDiagramViewPageBreaks
acCmdMicrosoftScriptEditor
acCmdNewObjectStoredProcedure
acCmdRemove
acCmdViewDiagrams
acCmdViewShowPaneGrid
acCmdViewTableequalNames
acCmdViewTableNameOnly
acCmdViewViews
acCmdDiagramAddRelatedTables
acCmdDiagramLayoutDiagram
acCmdDiagramNewLabel
acCmdDiagramShowRelationshipLabels
acCmdHidePane
acCmdNewObjectDiagram
acCmdQueryAddToOutput
acCmdViewDataAccessPages
acCmdViewShowPaneDiagram
acCmdViewTableKeys
acCmdViewVerifySQL
acCmdDataAccessPageDesignView
acCmdDiagramDeleteRelationship
acCmdDiagramModifyUserDefinedView
acCmdDiagramRecalculatePageBreaks
acCmdEditTriggers
acCmdNewObjectDataAccessPage
acCmdNewObjectView
acCmdSelectDataAccessPage
acCmdViewFieldList
acCmdViewShowPaneSQL
acCmdViewStoredProcedures
acCmdViewTableequalProperties
acCmdViewTableUserView
acCmdZoomSelection
Return to top

Kept for backwards compatibility with Access 97

acCmdBookmarksClearAll
acCmdBookmarksToggle
acCmdCompileAndSaveAllModules
acCmdDeleteWatch
acCmdInsertFileIntoModule
acCmdObjBrwFindWholeWordOnly
acCmdObjBrwShowHiddenMembers
acCmdParameterInfo
acCmdSaveAllModules
acCmdStepOut
acCmdToggleBreakpoint
acCmdBookmarksPrevious
acCmdClearAllBreakpoints
acCmdCompleteWord
acCmdFindPrevWordUnderCursor
acCmdListConstants
acCmdObjBrwHelp
acCmdObjectBrowser
acCmdReset
acCmdSingleStep
acCmdStepToCursor
acCmdBookmarksNext
acCmdCallStack
acCmdCompileLoadedModules
acCmdFindNextWordUnderCursor
acCmdLastPosition
acCmdObjBrwGroupMembers
acCmdObjBrwViewDefinition
acCmdReference
acCmdSaveModuleAsText
acCmdStepOver
Return to top

Kept for backwards compatibility with Access 97

The following are not marked as such in Access 2000 Help.

acCmdAddWatch
acCmdProcedureDefinition
Return to top

This site is best viewed in 1024 x 768