Microsoft Access 2010 Bible

(Rick Simeone) #1

Chapter 15: Using Access Data Macros


569


FIGURE 15.12

A simple macro that updates a local variable


Manipulating macro items
In Figure 15.13, notice that, when the If block is selected, not only is the block highlighted with
a gray background, but a delete icon (a graphical X) appears in the upper-right corner. You use the
X to delete the currently selected item (block, macro action, and so on) and remove it from the
macro. The macro deletes the item without confirmation, so be sure not to accidentally click the
Delete icon.

In Figure 15.13, although you can’t see it, the mouse is hovering over the SetLocalVar action.
As the mouse hovers over an item, green up-and-down arrows appear to the right of the item’s
area. You use these buttons to adjust the item’s position within a macro. For example, in a macro
containing multiple actions, you may find that the macro runs incorrectly because the actions
aren’t ordered properly. Use the up and down arrows to reposition the actions into the correct
sequence.
Free download pdf