Access AddMenu Access Example

Notes on AddMenu command:  You can set the MenuBar or ShortcutMenuBar property in VBA to attach a custom menubar to a form, control, or a report.

You can also set the StartupMenuBar property to establish a global menubar. Moreover can set the MenuBar property of the Application object to create a global menu bar. Similarly, you can set the StartupShortcutMenuBar property or the ShortcutMenuBar property of the Application object to install a global shortcut menu.

The AddMenu Command Syntax and Option Definitions:

MenuName Required Variant. A string expression that's the valid name of a drop-down menu to add to the custom menu bar or global menubar. To create an access key so that you can use the keyboard to choose the menu, type an ampersand (&) before the letter you want to be the access key. This letter will be underlined in the menu name on the menu bar.

MenuMacroName Required Variant. A string expression that's the valid name of the macro group that contains the macros for the menu's commands. This is a required argument.

StatusBarText Required Variant. A string expression that's the text to display in the status bar when the menu is selected

Find more about Managing Menu Bars and Menu Items at Microsoft.com.