Create custom menus and shortcut menus by using macros

What is Access

Microsoft Access is an information management tool that helps you store information for reference, reporting, and analysis. Microsoft Access helps you analyze large amounts of information , and manage related data more efficiently than Microsoft Excel or other spreadsheet applications.

Create custom menus and shortcut menus by using macros

You can use Access macros to create custom shortcut menus that appear when you right-click forms, reports, or individual controls. You can also create custom menus that appear on the Ribbon for specific forms or reports.

To create a menu by using macros, you perform three main steps:

1 Create a macro object with submacros that contain the menu commands.

2) Create another macro object that creates the menu itself.

3) Attach the menu to a control, a form, a report, or to the database as a whole.

Step 1: Create a macro object with submacros that contain the menu commands

What is a submacro?

You can use a submacro within a macro object to define a set of macro actions. Submacros within a macro object can be called separately from various control and object events. The individual submacros within a macro object each have a unique name and can contain one or more macro actions.

1) On the Create tab, in the Macros and Code group, click Macro.

2) For each command that you want on your custom Shortcut Menu:

      a) Add a Submacro Macro statement to the macro design window and name the submacro what you want to display on the shortcut menu (for example, "PrintView”).

      b) Within the submacro, select the first action you would like to take place when you click the command on the shortcut menu.

      c) If there are more actions that you want to take place when you select this command, add them as separate macro actions within the same submacro.

Save and name the macro object for example, MainMenu

Please watching My Video is Below

Design by Vannak Vannaro