MS-Access / Getting Started

Saving Named Data Macros

You've completed creating your first named data macro, but now you need to save it and give it a name. Unlike data macros attached to table events, named data macros require unique names. To save your new named data macro, click the Save button in the Close group on the Design contextual tab, or click the Save button on the Quick Access Toolbar. Access opens the Save As dialog box. Save the named data macro with the name ClearLogsTest.

Each named data macro attached to a table must have a unique name. You are allowed to have named data macros with the same if they are attached to different tables. If you attempt to save a named data macro with the same name as a named data macro attached to the same table, Access displays a warning message. If you click Yes, Access overwrites the existing named data macro with the new logic that you just defined.

[Previous] [Contents] [Next]

In this tutorial:

  1. Creating Table Data Macros
  2. Uses of Data Macros
  3. The Data Macro Design Facility
  4. Access New Logic Designer
  5. Working with Before Events
  6. Grouping Macros
  7. Using If Blocks to Create Conditional Expressions
  8. Raising Errors in Data Macros to Cancel Events
  9. Testing Your Data Macro
  10. Defining Multiple Actions
  11. Collapsing and Expanding Actions
  12. Moving Actions
  13. Preventing Duplicate Records Across Multiple Fields
  14. Before Delete
  15. Working with After Events
  16. After Update
  17. After Delete
  18. Working with Named Data Macros
  19. Saving Named Data Macros
  20. Calling Named Data Macros
  21. Renaming and Deleting Named Data Macros
  22. Analyzing Errors in the USysApplicationLog Table
  23. Using Parameters
  24. Using Local Variables
  25. Working with Return Variables
  26. Debugging Data Macros
  27. Understanding Recursion in Data Macros
  28. Sharing Data Macro Logic