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.
Control Menus
Toolbars
Shortcut Menus
Debug
Edit
File
Format
Help
Insert Query Records Relationships Run Tools View Window
Insert Query Records Relationships Run Tools View Window
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
- Run
- acCmdRun
- Select Query
- acCmdQueryTypeSelect
- Show Table
- acCmdShowTable
- SQL Specific - Data Definition
- acCmdQueryTypeSQLDataDefinition
- SQL Specific - Pass-Through
- acCmdQueryTypeSQLPassThrough
- SQL Specific - Union
- acCmdQueryTypeSQLUnion
- Update Query
- acCmdQueryTypeUpdate