Tuesday, July 29, 2014

How To Creating Macro Groups in Access 2003

If you have numerous macros, grouping related macros in macro groups can help you to manage them more easily. When Access runs a macro group, the first macro in the group starts with the first action, continuing until it reaches a new macro name or the last action in the window. To run a macro group, use the macro group name followed by the macro name. For example, you can refer to a macro group named Report1 in the Employees macro as Report1.Employees.

Create a Macro Group

graphics/1_icon.jpg
Open a macro in the Macro window.
graphics/2_icon.jpg
Click the Macro Names button.
graphics/3_icon.jpg
Type a name for the macro group next to the first action in the Macro Name column.
graphics/4_icon.jpg
Click the Save button to save your changes.
graphics/5_icon.jpg
Click the Close button.
graphics/13inf14.jpg

Did You Know?

You can display the Macro Name column. Display the Macro Name column by clicking Macro Names on the View menu.