Create a second macro object that creates the menu
Microsoft Access, on the other hand, is made to store and manage vast quantities of data in a form that makes it easy to retrieve and use in different applications. While Excel user’s type directly into their spreadsheets, Access databases are manipulated with pre-made forms and queries. Most businesses also connect Access to other applications, so when those other apps generate data, it's automatically ported over to Access.
This step might seem redundant, but to create the shortcut menu from the macro object that you created in Step 1, you must create a second macro object that contains the AddMenu macro action. This macro action is sometimes called the "menu macro.
1. On the Create tab, in the Macros & Code group, click Macro.
2. In the Add New Action combo box on the macro design window, select AddMenu.
3. In the Menu Name argument box for the AddMenu macro action, type the name of the menu (for example, "Form Commands"). This argument is not required, but is recommended if, in Step 3, you plan to add the menu to a Ribbon tab (such as the Add-Ins tab of a form or report). If the menu is added as a shortcut menu in Step 3, the Menu Name argument is ignored.
4.In the Menu Macro Name argument box, enter the name of the macro object that you created in Step 1.
5.Save and name this second macro object, for example, createMenu.
Create a second macro object that creates the menu
This step might seem redundant, but to create the shortcut menu from the macro object that you created in Step 1, you must create a second macro object that contains the AddMenu macro action. This macro action is sometimes called the "menu macro".
Please Watching My Video is Below
No comments:
Post a Comment