RunCommand constants are designed to allow the built-in menu functionality to be used in code. I
have tried to map the constants to their menu equivalent. However this is by no means an exact or
complete list, especially as functions move between menu items in different versions of Access. Also
the menus change as you work in different parts of Access. Select the menu that you require below.
Query Menu
Variations of this menu are available in Query Design and Query SQL.
Menu Item
RunCommand Equivalent
Append Query
acCmdQueryTypeAppend
Crosstab Query
acCmdQueryTypeCrosstab
Delete Query
acCmdQueryTypeDelete
Make Table Query
acCmdQueryTypeMakeTable
Parameters
acCmdQueryParameters
Remove Table
acCmdRemoveTable
Select Query
acCmdQueryTypeSelect
Show Table
acCmdShowTable
SQL Specific - Data Definition
acCmdQueryTypeSQLDataDefinition
SQL Specific - Pass-Through
acCmdQueryTypeSQLPassThrough
SQL Specific - Union
acCmdQueryTypeSQLUnion
Update Query
acCmdQueryTypeUpdate