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 acCmdD

Constant
Description
Value

acCmdDataAccessPageAddToPage
 
480

acCmdDataAccessPageBrowse
Changes from Design View to Page View of a Data Access Page
344

acCmdDataAccessPageDesignView
Changes from Page View to Design View of a Data Access Page
385

acCmdDataAccessPageFieldListRefresh
 
479

acCmdDatabaseProperties
Display the database properties dialog
256

acCmdDatabaseSplitter
 
520

Code ExampleacCmdDataEntry
Changes view to data entry mode
78

acCmdDataOutline
 
468

Code ExampleacCmdDatasheetView
Switches to datasheet view
282

acCmdDateAndTime
Displays the Date and Time dialog
226

Code ExampleacCmdDebugWindow
Displays the immediate window but you have to open a module first
123

acCmdDelete
Deletes selected item. Available in both VBE and non-VBE views
337

acCmdDeleteGroup
I presume that this removes a user created group fro the database window
493

acCmdDeletePage
Deletes a page from a tab control
332

acCmdDeleteQueryColumn
Removes a column from the QBE grid
81

Code ExampleacCmdDeleteRecord
Deletes the selected record
223

acCmdDeleteRows
Deletes rows but where I am not sure
188

acCmdDeleteSharePointList
 
627

acCmdDeleteTab
Not used to delete a tab from a tab control that is acCmdDeletePage
255

acCmdDeleteTable
I presume this deletes a table from an Access Data Project
489

acCmdDeleteTableColumn
Deletes the selected column from a table
271

acCmdDeleteWatch
Deletes the selected watch variable
267

acCmdDemote
Used on Data Access Pages to demote a Group heading
388

Code ExampleacCmdDesignView
Switches to Design View
183

acCmdDiagramAddRelatedTables
 
373

acCmdDiagramAutosizeSelectedTables
 
378

acCmdDiagramDeleteRelationship
 
382

acCmdDiagramLayoutDiagram
 
380

acCmdDiagramLayoutSelection
 
379

acCmdDiagramModifyUserDefinedView
 
375

acCmdDiagramNewLabel
 
372

acCmdDiagramNewTable
 
381

acCmdDiagramRecalculatePageBreaks
 
377

acCmdDiagramShowRelationshipLabels
 
374

acCmdDiagramViewPageBreaks
 
376

acCmdDiscardChanges
 
639

acCmdDiscardChangesAndRefresh
 
640

Code ExampleacCmdDocMaximize
Maximizes Access child window. Available in both VBE and non-VBE views
15

Code ExampleacCmdDocMinimize
Minimize internal Access window. Available in both VBE and non-VBE views
60

Code ExampleacCmdDocMove
Move Access child window. Available in both VBE and non-VBE views
16

Code ExampleacCmdDocRestore
Restores Access child window. Available in both VBE and non-VBE views
14

Code ExampleacCmdDocSize
Size Access child window. Available in both VBE and non-VBE views
17

Code ExampleacCmdDocumenter
Displays the Documentor dialog
285

acCmdDropSQLDatabase
 
517

Code ExampleacCmdDuplicate
Create a duplicate of the selected object
34