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 acCmdT

Constant
Value
Description
acCmdTabControlPageOrder
330
Displays the Page Order dialog
acCmdTableAddTable
498
Displays the Add Table dialog in an Access Project
acCmdTableCustomView
497
 
acCmdTableNames
75
Toggles display of the Table Names Line in a QBE grid
Code ExampleacCmdTabOrder
41
Displays the Tab Order dialog
acCmdTabularLayout
569
 
acCmdTestValidationRules
196
Tests a table's validation rules
Code ExampleacCmdTileHorizontally
286
Tiles the Access child windows horizontally
Code ExampleacCmdTileVertically
23
Tiles the Access child windows vertically
acCmdToggleBreakpoint
131
Turns a break point on/off
acCmdToggleCacheListData
642
 
Code ExampleacCmdToggleFilter
220
Toggles a filter on/off
acCmdToggleOffline
540
 
acCmdToolbarControlProperties
301
Display properties for controls on Toolbars from the customize box?
acCmdToolbarsCustomize
165
Displays the Customize Toolbars dialog. Available in both VBE and non-VBE views
acCmdTransferSQLDatabase
515
 
acCmdTransparentBackground
288
Sets the background of a control to transparent
acCmdTransparentBorder
289
Sets the border color of a control to transparent

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