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 or Access 2007. 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 acCmdN
Constant
Value
Description
acCmdNewDatabase
26
Opens the new database dialog
acCmdNewGroup
491
Creates a new group in the database window
acCmdNewObjectAutoForm
193
Creates a new form if a table/query has been selected in the database window
acCmdNewObjectAutoReport
194
Creates a new report if a table/query has been selected in the database window
acCmdNewObjectBlankForm
600
acCmdNewObjectBlankReport
602
acCmdNewObjectClassModule
140
Creates a new Class Module
acCmdNewObjectContinuousForm
594
acCmdNewObjectDataAccessPage
346
Opens the new Data Access Page dialog
acCmdNewObjectDatasheetForm
598
acCmdNewObjectDesignForm
604
acCmdNewObjectDesignQuery
603
acCmdNewObjectDesignReport
605
acCmdNewObjectDesignTable
606
acCmdNewObjectDiagram
352
Opens a new Diagram in design mode
acCmdNewObjectForm
136
Displays the New Form dialog
acCmdNewObjectFunction
394
acCmdNewObjectLabelsReport
601
acCmdNewObjectMacro
138
Opens a New Macro Window
acCmdNewObjectModalForm
599
acCmdNewObjectModule
139
Creates a new Module
acCmdNewObjectPivotChart
596
acCmdNewObjectPivotTable
597
acCmdNewObjectQuery
135
Displays the New Query dialog
acCmdNewObjectReport
137
Displays the New Report dialog
acCmdNewObjectSplitForm
595
acCmdNewObjectStoredProcedure
351
Opens a new Stored Procedure in design mode
acCmdNewObjectTable
134
Displays the New Table dialog
acCmdNewObjectView
350
Opens a new View in design mode