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 acCmdT

Constant
Description
Value

acCmdTabControlPageOrder
Displays the Page Order dialog
330

acCmdTableAddTable
 
498

acCmdTableCustomView
 
497

acCmdTableNames
Toggles display of the Table Names Line in a QBE grid
75

Code ExampleacCmdTabOrder
Displays the Tab Order dialog
41

acCmdTabularLayout
 
569

acCmdTestValidationRules
Tests a table's validation rules
196

Code ExampleacCmdTileHorizontally
Tiles the Access child windows horizontally
286

Code ExampleacCmdTileVertically
Tiles the Access child windows vertically
23

acCmdToggleBreakpoint
Turns a break point on/off
131

acCmdToggleCacheListData
 
642

Code ExampleacCmdToggleFilter
Toggles a filter on/off
220

acCmdToggleOffline
 
540

acCmdToolbarControlProperties
Display properties for controls on Toolbars from the customize box?
301

acCmdToolbarsCustomize
Displays the Customize Toolbars dialog. Available in both VBE and non-VBE views
165

acCmdTransferSQLDatabase
 
515

acCmdTransparentBackground
Sets the background of a control to transparent
288

acCmdTransparentBorder
Sets the border color of a control to transparent
289