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

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

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