MS-Access / Getting Started

Documenting Macros

Because macros are database objects, they're listed in the database Properties dialog box on the Contents tab. To view the list, click the Microsoft Office button, point to Manage, and choose Database Properties. Then click the Contents tab in the Properties dialog box and scroll down the list until you reach the macro section.

If you want to keep documentation for the standalone macros and macro groups in your database, you can print the macro description by using the Database Documenter. On the Database Tools tab's Analyze group, click the Database Documenter command. Select the Macros tab, choose the macro you want, and click OK. Choose Options, and in the Print Macro Definition dialog box, check the categories of information that you want to print:

  • Properties Includes the container, date created, date of last update, owner, and user.
  • Actions and Arguments Lists all the actions with their conditions, if any, and the values of all the arguments.
  • Permissions by User and Group Lists user permissions, such as admin, and group permissions, such as Admins and Users.

Then click OK again to see the macro definitions in Print Preview.

[Previous] [Contents] [Next]

In this tutorial:

  1. Automating with Macros
  2. Standalone vs. Embedded Macros
  3. Creating a Macro
  4. Choosing Actions
  5. Testing and Debugging a Macro
  6. Adding Conditions to a Macro
  7. Assigning a Macro to an Event Property
  8. Some Common Uses for Macros
  9. Filtering Records
  10. Changing the Flow of Operations
  11. Create a Macro Group
  12. Documenting Macros
  13. Creating an AutoExec Macro