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