Menu Equivalents

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

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

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