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 acCmdQ

Constant
Value
Description
acCmdQueryAddToOutput
362
Adds a field to the output of a View
acCmdQueryGroupBy
361
Adds and hides the Group By column in the design of a View
acCmdQueryParameters
76
Displays the Parameters dialog
acCmdQueryTotals
73
Toggles the Totals Line in a QBE grid
acCmdQueryTypeAppend
91
Changes a Query to an Append Query
acCmdQueryTypeCrosstab
74
Changes a Query to a Crosstab
acCmdQueryTypeDelete
92
Changes a Query to a Delete Query
acCmdQueryTypeMakeTable
94
Changes a Query to a Make Table Query
acCmdQueryTypeSelect
89
Changes a Query to a Select Query
acCmdQueryTypeSQLDataDefinition
168
Changes the Query to a Data Definition Query
acCmdQueryTypeSQLPassThrough
169
Changes the Query to a Pass Through Query
acCmdQueryTypeSQLUnion
180
Changes the Query to a Union Query
acCmdQueryTypeUpdate
90
Changes a Query to an Update Query
acCmdQuickInfo
304
Displays syntax help
acCmdQuickPrint
278
Prints without displaying the print dialog box
acCmdQuickWatch
203
Displays the Quick Watch dialog

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