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 acCmdV

Constant
Value
Description
Code ExampleacCmdVerticalSpacingDecrease
161
Decreases the vertical space between selected objects
Code ExampleacCmdVerticalSpacingIncrease
162
Increases the vertical space between selected objects
Code ExampleacCmdVerticalSpacingMakeEqual
160
Makes the vertical space between selected objects equal
Code ExampleacCmdViewCode
170
Opens the Code window for the selected object
Code ExampleacCmdViewDataAccessPages
349
Displays the Pages tab in Database Window
acCmdViewDetails
210
Displays details in database window
acCmdViewDiagrams
354
Displays the Diagrams tab of the database window of an Access Data Project
acCmdViewFieldList
353
Displays and hides the Field List in a View
Code ExampleacCmdViewForms
112
Displays the Form tab in Database Window
acCmdViewFunctions
395
 
acCmdViewGrid
63
Toggles display of the Grid in form and report design view
acCmdViewLargeIcons
209
Displays large icons in database window
acCmdViewList
212
Displays items in a list in the database window
Code ExampleacCmdViewMacros
114
Displays the Macro tab in Database Window
Code ExampleacCmdViewModules
115
Displays the Module tab in Database Window
acCmdViewObjectDependencies
536
 
Code ExampleacCmdViewQueries
111
Displays the Query tab in Database Window
Code ExampleacCmdViewReports
113
Displays the Report tab in Database Window
Code ExampleacCmdViewRuler
61
Toggles the display of the ruler in form and report design
acCmdViewShowPaneDiagram
358
Toggles the display of the Diagram Pane when in the design of a View
acCmdViewShowPaneGrid
359
Toggles the display of the Grid Pane when in the design of a View
acCmdViewShowPaneSQL
357
Toggles the display of the SQL Pane when in the design of a View
acCmdViewSmallIcons
211
Displays small icons in database window
acCmdViewStoredProcedures
355
Displays the Stored Procedures tab of the database window in an Access Data Project
acCmdViewTableColumnNames
363
 
acCmdViewTableColumnProperties
368
 
acCmdViewTableKeys
369
 
acCmdViewTableNameOnly
364
 
Code ExampleacCmdViewTables
110
Displays the Table tab in Database Window
acCmdViewTableUserView
370
 
Code ExampleacCmdViewToolbox
85
Toggles the display of the Toolbox in form and report design
acCmdViewVerifySQL
360
Verifies the SQL in the design of a View
Code Example acCmdViewViews
356
Display the views tab of the database window in an Access Data Project
acCmdVisualBasicEditor
525
Opens the Visual Basic Editor

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