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
Records
Variations of this menu are available in the following areas of Access: Form Datasheet, Form View, Query Datasheet, Table Datasheet
- Menu Item
- RunCommand Equivalent
- Apply Filter/Sort
- acCmdApplyFilterSort
- Data Entry
- acCmdDataEntry
- Filter - Advanced Filter/Sort
- acCmdAdvancedFilterSort
- Filter - Filter by Form
- acCmdFilterByForm
- Filter - Filter by Selection
- acCmdFilterBySelection
- Filter - Filter Excluding Selection
- acCmdFilterExcludingSelection
- Refresh
- acCmdRefresh
- Remove Filter/Sort
- acCmdRemoveFilterSort
- Save Record
- acCmdSaveRecord
- Sort - Sort Ascending
- acCmdSortAscending
- Sort - Sort Descending
- acCmdSortDescending