Macros can be saved into the database’s navigation pane or be embedded inside of other objects. In this video, Access database expert Adam Wilbert shows how to create and edit an embedded macro created with the button wizard. He also demonstrates how to create a new embedded macro inside of an empty event property.
- [Instructor] When macros are created…using the Button Wizard they don't save…into the navigation pane.…Instead they get created inside of the object…that they're attached to.…We can see that by taking the main menu form…and switching it into Design view.…Then in the Controls group, I'll click on the Button button…and we'll go down and add in a new button into our form.…That'll start up the Command Button Wizard.…Now for this example, I'm going to go into…the Report Operations category,…and choose the Mail Report action.…This'll email a report of our choosing.…You can press the Next button.…Access will need to know which report we want to email.…
I'll choose the Orders by State report, and press Next.…Then we'll go ahead and define what we want to see…on the button, I'm going to choose the Text option,…we'll just leave it as Mail Report, I'll press Next,…and we'll give our button a meaningful name.…I'll call it btnMailReport.…I'll press Finish to create my button.…Now if I take a look in the Property Sheet for this button,…
- Creating multi-step macros
- Triggering macros
- Running macros at startup
- Adjusting the execution and flow of macros
- Troubleshooting macros