Access AddMenu DoCmd 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.
Microsoft Access is a fully capable database and it's primary limitations is the number of concurrent users it will support. Generally, we recommend a limit of 10 to 15 users.
Did you know you don't need to move to SQL/Server to run and manage your Access database on the net. There are many alternative solutions. Among them are Amazon's AWS cloud services and various hosting services in nearly every state.
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
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