Here is a complete list of RunCommand constants with a description of their function where I know what they do.
The list in Access Help and the one obtainable on the Microsoft Web Site are incomplete and contradict one another.
I have colour coded the list dependent on the version in which they first appeared -
Access 97, Access 2000, Access XP,
Access 2003, Access 2007 or Access 2010. Prior to Access 2007, all later
versions of Access recognise the earlier commands. See Known Problems for more details.
Some of these were retained for backwards compatibility only. If you spot any errors or can fill the gaps please
let me know.
links to code examples for that constant. Select the start letter,
ignoring the acCmd, of the constant.
Select the sixth letter of the acCmdConstant
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
Constants starting acCmdD
Constant
Value
Description
acCmdDataAccessPageAddToPage
480
I think this must be equivalent to the Add To Page Button on the Field List in design view of a Data Access Page
acCmdDataAccessPageBrowse
344
Changes from Design View to Page View of a Data Access Page
acCmdDataAccessPageDesignView
385
Changes from Page View to Design View of a Data Access Page
acCmdDataAccessPageFieldListRefresh
479
I think this must be equivalent to the Refresh Button on the Field List in design view of a Data Access Page
acCmdDatabaseProperties
256
Display the database properties dialog
acCmdDatabaseSplitter
520
Automatically splits the current database into 2. A front end containing everything but the data and a back end containing the tables.
acCmdDataEntry
78
Changes view to data entry mode
acCmdDataOutline
468
I think this must be equivalent to the Data Outline Button on the toolbar in design view of a Data Access Page
acCmdDatasheetView
282
Switches to datasheet view
acCmdDateAndTime
226
Displays the Date and Time dialog
acCmdDebugWindow
123
Displays the immediate window but you have to open a module first
acCmdDelete
337
Deletes selected item. Available in both VBE and non-VBE views
acCmdDeleteGroup
493
I presume that this removes a user created group fro the database window
acCmdDeletePage
332
Deletes a page from a tab control
acCmdDeleteQueryColumn
81
Removes a column from the QBE grid
acCmdDeleteRecord
223
Deletes the selected record
acCmdDeleteRows
188
Deletes rows but where I am not sure
acCmdDeleteSharePointList
627
Deletes the currently open SharePoint list
acCmdDeleteTab
255
Not used to delete a tab from a tab control that is acCmdDeletePage
acCmdDeleteTable
489
I presume this deletes a table from an Access Data Project
acCmdDeleteTableColumn
271
Deletes the selected column from a table
acCmdDeleteWatch
267
Deletes the selected watch variable
acCmdDemote
388
Used on Data Access Pages to demote a Group heading
acCmdDesignView
183
Switches to Design View
acCmdDiagramAddRelatedTables
373
acCmdDiagramAutosizeSelectedTables
378
acCmdDiagramDeleteRelationship
382
acCmdDiagramLayoutDiagram
380
acCmdDiagramLayoutSelection
379
acCmdDiagramModifyUserDefinedView
375
acCmdDiagramRecalculatePageBreaks
377
Equivalent to right clicking on a diagram and selecting Recalculate Page Breaks
acCmdDiagramShowRelationshipLabels
374
acCmdDiagramViewPageBreaks
376
Equivalent to selecting View Page Breaks from the Diagram menu
acCmdDiscardChangesAndRefresh
640
acCmdDocMaximize
15
Maximizes Access child window. Available in both VBE and non-VBE views
acCmdDocMinimize
60
Minimize internal Access window. Available in both VBE and non-VBE views
acCmdDocMove
16
Move Access child window. Available in both VBE and non-VBE views
acCmdDocRestore
14
Restores Access child window. Available in both VBE and non-VBE views
acCmdDocSize
17
Size Access child window. Available in both VBE and non-VBE views
acCmdDocumenter
285
Displays the Documentor dialog
acCmdDuplicate
34
Create a duplicate of the selected object
Site developed, maintained and hosted by TKW Design. This site is best viewed at 1024 x 768. Optimised for Firefox.