• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

1. Core Access > 6. Organize and Enhance Your Macros

Organize and Enhance Your Macros

Optimize and reduce the number of macros using the optional name and condition columns.

Macros are often used for small automations—usually for tasks that aren’t too complex or sophisticated because VBA is available to handle the heavy processing. Let’s think that way no more. Actually, macros can handle a decent amount of intelligent processing and, in fact, have a condition-testing ability similar to the If…Then structure in VBA. This hack shows you how to transform a single macro into a multipurpose workhorse.

Conditional Macro Actions

Macros have but a single mandatory column: the Action column. A macro can have one or more actions. However, macros also have an optional Condition column, in which a little entry can go a long way toward adding some punch to the process. When you’re designing a macro, use the View menu to display the Condition column.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint