Full List of All RunCommand Constants

Here is a complete list of RunCommand constants with a description of their function where I know what they do. Both the list in Access Help and the list 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.

Code Link 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
Description
Value

acCmdNewDatabase
Opens the new database dialog
26

Code ExampleacCmdNewGroup
Creates a new group in the database window
491

Code ExampleacCmdNewObjectAutoForm
Creates a new form if a table/query has been selected in the database window
193

Code ExampleacCmdNewObjectAutoReport
Creates a new report if a table/query has been selected in the database window
194

acCmdNewObjectBlankForm
 
600

acCmdNewObjectBlankReport
 
602

Code ExampleacCmdNewObjectClassModule
Creates a new Class Module
140

acCmdNewObjectContinuousForm
 
594

acCmdNewObjectDataAccessPage
Opens the new Data Access Page dialog
346

acCmdNewObjectDatasheetForm
 
598

acCmdNewObjectDesignForm
 
604

acCmdNewObjectDesignQuery
 
603

acCmdNewObjectDesignReport
 
605

acCmdNewObjectDesignTable
 
606

acCmdNewObjectDiagram
Opens a new Diagram in design mode
352

acCmdNewObjectForm
Displays the New Form dialog
136

acCmdNewObjectFunction
 
394

acCmdNewObjectLabelsReport
 
601

Code ExampleacCmdNewObjectMacro
Opens a New Macro Window
138

acCmdNewObjectModalForm
 
599

Code ExampleacCmdNewObjectModule
Creates a new Module
139

acCmdNewObjectPivotChart
 
596

acCmdNewObjectPivotTable
 
597

Code ExampleacCmdNewObjectQuery
Displays the New Query dialog
135

Code ExampleacCmdNewObjectReport
Displays the New Report dialog
137

acCmdNewObjectSplitForm
 
595

acCmdNewObjectStoredProcedure
Opens a new Stored Procedure in design mode
351

acCmdNewObjectTable
Displays the New Table dialog
134

acCmdNewObjectView
Opens a new View in design mode
350