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. 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.

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
Value
Description
acCmdNewDatabase
26
Opens the new database dialog
Code ExampleacCmdNewGroup
491
Creates a new group in the database window
Code ExampleacCmdNewObjectAutoForm
193
Creates a new form if a table/query has been selected in the database window
acCmdNewObjectAutoFormWeb
705
Code ExampleacCmdNewObjectAutoReport
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
Code ExampleacCmdNewObjectClassModule
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
 
Code ExampleacCmdNewObjectMacro
138
Opens a New Macro Window
acCmdNewObjectMacroWeb
708
acCmdNewObjectModalForm
599
 
Code ExampleacCmdNewObjectModule
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
 
Code ExampleacCmdNewObjectQuery
135
Displays the New Query dialog
acCmdNewObjectQueryWeb
707
Code ExampleacCmdNewObjectReport
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

© 1998 - 2011 Terry Wickenden TKW Design Site developed, maintained and hosted by TKW Design. This site is best viewed at 1024 x 768. Optimised for Firefox.