ACC2: Sample DoMenuItem Access Basic Statements

This article was previously published under Q128425
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.
SUMMARY
This article lists the Access Basic DoMenuItem action statements that youcan use to activate menu items in the Form view menu bar and the Databasewindow menu bar.
MORE INFORMATION
This article assumes that you are familiar with the DoMenuItem action andhow it can be used in Access Basic. This article also assumes that you arefamiliar with Access Basic and with creating Microsoft Access applicationsusing the programming tools provided with Microsoft Access. For moreinformation about Access Basic, please refer to the "Building Applications"manual.

NOTE: In the following examples, an underscore (_) at the end of a line isused as a line-continuation character. Remove the underscore from the endof the line when you re-create these examples.

Form View Menu Bar

File   New      Table         DoCmd DoMenuItem A_FORMBAR, A_FILE, A_NEW,0, A_MENU_VER20      Query         DoCmd DoMenuItem A_FORMBAR, A_FILE, A_NEW,1, A_MENU_VER20      Form         DoCmd DoMenuItem A_FORMBAR, A_FILE, A_NEW,2, A_MENU_VER20      Report         DoCmd DoMenuItem A_FORMBAR, A_FILE, A_NEW,3, A_MENU_VER20      Macro         DoCmd DoMenuItem A_FORMBAR, A_FILE, A_NEW,4, A_MENU_VER20      Module         DoCmd DoMenuItem A_FORMBAR, A_FILE, A_NEW,5, A_MENU_VER20   Close                         (see also Close action)      DoCmd DoMenuItem A_FORMBAR, A_FILE, 1,, A_MENU_VER20   Save Form            CTRL+S      DoCmd DoMenuItem A_FORMBAR, A_FILE, A_SAVEFORM,, A_MENU_VER20   Save Form As      DoCmd DoMenuItem A_FORMBAR, A_FILE, A_SAVEFORMAS,, A_MENU_VER20   Save Record          SHIFT+ENTER      DoCmd DoMenuItem A_FORMBAR, A_FILE, A_SAVERECORD,, A_MENU_VER20   Output To                 (see also OutputTo action)      DoCmd DoMenuItem A_FORMBAR, A_FILE, 5,, A_MENU_VER20   Print Setup      DoCmd DoMenuItem A_FORMBAR, A_FILE, 6,, A_MENU_VER20   Print Preview      DoCmd DoMenuItem A_FORMBAR, A_FILE, 7,, A_MENU_VER20   Print                CTRL+P   (see also Print action)      DoCmd DoMenuItem A_FORMBAR, A_FILE, 8,, A_MENU_VER20   Send      DoCmd DoMenuItem A_FORMBAR, A_FILE, 9,, A_MENU_VER20   Run Macro                     (see also RunMacro action)      DoCmd DoMenuItem A_FORMBAR, A_FILE, 10,, A_MENU_VER20   Add-ins      NOT AVAILABLE   Exit                          (see also Quit action)      DoCmd DoMenuItem A_FORMBAR, A_FILE, 12,, A_MENU_VER20Edit   Undo Typing          CTRL+Z      DoCmd DoMenuItem A_FORMBAR, A_EDITMENU, A_UNDO,, A_MENU_VER20   Undo Current Field / Undo Current Record  ESC      DoCmd DoMenuItem A_FORMBAR, A_EDITMENU, A_UNDOFIELD,, A_MENU_VER20   Cut                  CTRL+X      DoCmd DoMenuItem A_FORMBAR, A_EDITMENU, A_CUT,, A_MENU_VER20   Copy                 CTRL+C      DoCmd DoMenuItem A_FORMBAR, A_EDITMENU, A_COPY,, A_MENU_VER20   Paste                CTRL+V      DoCmd DoMenuItem A_FORMBAR, A_EDITMENU, A_PASTE,, A_MENU_VER20   Paste Special      DoCmd DoMenuItem A_FORMBAR, A_EDITMENU, 5,, A_MENU_VER20   Paste Append      DoCmd DoMenuItem A_FORMBAR, A_EDITMENU, 6,, A_MENU_VER20   Delete               DEL      DoCmd DoMenuItem A_FORMBAR, A_EDITMENU, A_DELETE_V2,, A_MENU_VER20   Select Record      DoCmd DoMenuItem A_FORMBAR, A_EDITMENU, A_SELECTRECORD_V2,,_      A_MENU_VER20   Select All Records   CTRL+A      DoCmd DoMenuItem A_FORMBAR, A_EDITMENU, A_SELECTALLRECORDS_V2,,_      A_MENU_VER20   Find             CTRL+F      (see also FindRecord action)      DoCmd DoMenuItem A_FORMBAR, A_EDITMENU, 10,, A_MENU_VER20   Replace          CTRL+H      DoCmd DoMenuItem A_FORMBAR, A_EDITMENU, 11,, A_MENU_VER20   Insert Object      DoCmd DoMenuItem A_FORMBAR, A_EDITMENU, 12,, A_MENU_VER20   Links      DoCmd DoMenuItem A_FORMBAR, A_EDITMENU, 13,, A_MENU_VER20   Object      Object Verb         DoCmd DoMenuItem A_FORMBAR, A_EDITMENU, A_OBJECT, A_OBJECTVERB,_         A_MENU_VER20View   Form Design      DoCmd DoMenuItem A_FORMBAR, 2, 0,, A_MENU_VER20   Form      DoCmd DoMenuItem A_FORMBAR, 2, 1,, A_MENU_VER20   Datasheet      DoCmd DoMenuItem A_FORMBAR, 2, 2,, A_MENU_VER20   Subform Datasheet      DoCmd DoMenuItem A_FORMBAR, 2, 3,, A_MENU_VER20   Toolbars      DoCmd DoMenuItem A_FORMBAR, 2, 4,, A_MENU_VER20   Options      DoCmd DoMenuItem A_FORMBAR, 2, 5,, A_MENU_VER20Records   DataEntry      DoCmd DoMenuItem A_FORMBAR, A_RECORDSMENU, ,, A_MENU_VER20   Goto                          (see also GotoRecord action)      First         DoCmd DoMenuItem A_FORMBAR, A_RECORDSMENU, 1, 0, A_MENU_VER20      Last         DoCmd DoMenuItem A_FORMBAR, A_RECORDSMENU, 1, 1, A_MENU_VER20      Next         DoCmd DoMenuItem A_FORMBAR, A_RECORDSMENU, 1, 2, A_MENU_VER20      Previous         DoCmd DoMenuItem A_FORMBAR, A_RECORDSMENU, 1, 3, A_MENU_VER20      New         DoCmd DoMenuItem A_FORMBAR, A_RECORDSMENU, 1, 4, A_MENU_VER20   Refresh      DoCmd DoMenuItem A_FORMBAR, A_RECORDSMENU, A_REFRESH,, A_MENU_VER20   Quick Sort      Ascending         DoCmd DoMenuItem A_FORMBAR, A_RECORDSMENU, 3,0, A_MENU_VER20      Descending         DoCmd DoMenuItem A_FORMBAR, A_RECORDSMENU, 3,1, A_MENU_VER20   Edit Filter/Sort      DoCmd DoMenuItem A_FORMBAR, A_RECORDSMENU, 4,, A_MENU_VER20   Apply Filter/Sort             (see also ApplyFilter action)      DoCmd DoMenuItem A_FORMBAR, A_RECORDSMENU, 5,, A_MENU_VER20   Show All Records              (see also ShowAllRecords action)      DoCmd DoMenuItem A_FORMBAR, A_RECORDSMENU, 6,, A_MENU_VER20   Allow Editing      DoCmd DoMenuItem A_FORMBAR, A_RECORDSMENU, 7,, A_MENU_VER20Window   Tile      DoCmd DoMenuItem A_FORMBAR, 4, 0,, A_MENU_VER20   Cascade      DoCmd DoMenuItem A_FORMBAR, 4, 1,, A_MENU_VER20   Arrange Icons      DoCmd DoMenuItem A_FORMBAR, 4, 2,, A_MENU_VER20   Hide      DoCmd DoMenuItem A_FORMBAR, 4, 3,, A_MENU_VER20   Unhide      DoCmd DoMenuItem A_FORMBAR, 4, 4,, A_MENU_VER20   Size to Fit Form      DoCmd DoMenuItem A_FORMBAR, 4, 5,, A_MENU_VER20Help   Contents      DoCmd DoMenuItem A_FORMBAR, 5, 0,, A_MENU_VER20   Search      DoCmd DoMenuItem A_FORMBAR, 5, 1,, A_MENU_VER20   Cue Cards      DoCmd DoMenuItem A_FORMBAR, 5, 2,, A_MENU_VER20   Technical Support      DoCmd DoMenuItem A_FORMBAR, 5, 3,, A_MENU_VER20   About Microsoft Access      DoCmd DoMenuItem A_FORMBAR, 5, 4,, A_MENU_VER20				

Database Window Menu Bar

NOTE: Before you specify a DoMenuItem action, set the focus to the Databasewindow. To do so, use the SelectObject action to select the default objectin the list of available tables in the Database window with the following:
   DoCmd SelectObject A_TABLE, , TrueFile   New Database CTRL+N      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, A_FILE, 0,, A_MENU_VER20   Open Database CTRL+O      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, A_FILE, 1,, A_MENU_VER20   Close Database      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, A_FILE, 2,, A_MENU_VER20   New      Table         DoCmd SelectObject A_TABLE, , True         DoCmd DoMenuItem 1, A_FILE, 3, 0, A_MENU_VER20      Query         DoCmd SelectObject A_TABLE, , True         DoCmd DoMenuItem 1, A_FILE, 3, 1, A_MENU_VER20      Form         DoCmd SelectObject A_TABLE, , True         DoCmd DoMenuItem 1, A_FILE, 3, 2, A_MENU_VER20      Report         DoCmd SelectObject A_TABLE, , True         DoCmd DoMenuItem 1, A_FILE, 3, 3, A_MENU_VER20      Macro         DoCmd SelectObject A_TABLE, , True         DoCmd DoMenuItem 1, A_FILE, 3, 4, A_MENU_VER20      Module         DoCmd SelectObject A_TABLE, , True         DoCmd DoMenuItem 1, A_FILE, 3, 5, A_MENU_VER20   Rename                       (see also Rename action)      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, A_FILE, 4,, A_MENU_VER20   Output To                    (see also OutputTo action)      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, A_FILE, 5,, A_MENU_VER20   Import                       (see also Transfer actions)      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, A_FILE, 6,, A_MENU_VER20   Export                       (see also Transfer actions)      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, A_FILE, 7,, A_MENU_VER20   Attach Table                 (see also TransferDatabase action)      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, A_FILE, 8,, A_MENU_VER20   Imp/Exp Setup      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, A_FILE, 9,, A_MENU_VER20   Print Setup      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, A_FILE, 10,, A_MENU_VER20   Print Preview      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, A_FILE, 11,, A_MENU_VER20   Print    CTRL+P               (see also Print action)      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, A_FILE, 12,, A_MENU_VER20   Print Definition      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, A_FILE, 13,, A_MENU_VER20   Send      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, A_FILE, 14,, A_MENU_VER20   Run Macro                    (see also RunMacro action)      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, A_FILE, 15,, A_MENU_VER20   Add-ins      NOT AVAILABLE   Exit                          (see also Quit action)      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, A_FILE, 17,, A_MENU_VER20Edit   Undo      NOT AVAILABLE   Cut CTRL+X      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, A_EDITMENU, 1,, A_MENU_VER20   Copy CTRL+C      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, A_EDITMENU, 2,, A_MENU_VER20   Paste CTRL+V      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, A_EDITMENU, 3,, A_MENU_VER20   Delete DEL      DoCmd SelectObject A_TABLE, , True     DoCmd DoMenuItem 1, A_EDITMENU, 4,, A_MENU_VER20   Relationships      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, A_EDITMENU, 5,, A_MENU_VER20Security   Permissions      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, 3, 0,, A_MENU_VER20   Users      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, 3, 1,, A_MENU_VER20   Groups      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, 3, 2,, A_MENU_VER20   Change Password      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, 3, 3,, A_MENU_VER20   Change Owner      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, 3, 4,, A_MENU_VER20   Print Security      DoCmd SelectObject A_TABLE, , True      DoCmd DoMenuItem 1, 3, 5,, A_MENU_VER20				
REFERENCES
For more information about the DoMenuItem action, search for "DoMenuItem,"and then "DoMenuItem Action" using the Microsoft Access 2.0 Help menu.
Properties

Article ID: 128425 - Last Review: 12/04/2015 11:12:26 - Revision: 1.1

Microsoft Access 2.0 Standard Edition

  • kbnosurvey kbarchive kbinfo kbusage KB128425
Feedback