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 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
acCmdNewObjectAutoFormWeb
705
acCmdNewObjectAutoReport
194
Creates a new report if a table/query has been selected in the database window
acCmdNewObjectAutoReportWeb
706
acCmdNewObjectBlankForm
600
acCmdNewObjectBlankFormWeb
703
acCmdNewObjectBlankReport
602
acCmdNewObjectBlankReportWeb
704
acCmdNewObjectClassModule
140
Creates a new Class Module
acCmdNewObjectContinuousForm
594
acCmdNewObjectContinuousFormWeb
701
acCmdNewObjectDataAccessPage
346
Opens the new Data Access Page dialog
acCmdNewObjectDatasheetForm
598
acCmdNewObjectDatasheetFormWeb
702
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
acCmdNewObjectMacroWeb
708
acCmdNewObjectModalForm
599
acCmdNewObjectModule
139
Creates a new Module
acCmdNewObjectNavigationLeft
690
acCmdNewObjectNavigationLeftWeb
710
acCmdNewObjectNavigationRight
691
acCmdNewObjectNavigationRightWeb
711
acCmdNewObjectNavigationTop
689
acCmdNewObjectNavigationTopLeft
693
acCmdNewObjectNavigationTopLeftWeb
713
acCmdNewObjectNavigationTopRight
694
acCmdNewObjectNavigationTopRightWeb
714
acCmdNewObjectNavigationTopTop
692
acCmdNewObjectNavigationTopTopWeb
712
acCmdNewObjectNavigationTopWeb
709
acCmdNewObjectPivotChart
596
acCmdNewObjectPivotTable
597
acCmdNewObjectQuery
135
Displays the New Query dialog
acCmdNewObjectQueryWeb
707
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
Site developed, maintained and hosted by TKW Design. This site is best viewed at 1024 x 768. Optimised for Firefox.