Modifying an Existing Macro
You have learned how to create a macro, add macro actions and their associated arguments, create macro subroutines by adding macro names, and conditionally execute the actions in the macro by adding macro conditions. However, after you have created a macro, you might want to modify it. To do so, you must first enter Design view for the macro and then follow these steps:
Click the Macros tab of the Database window. Select the macro you want to modify. Click Design.
When the design of the macro appears, you can insert new lines, delete existing lines, move the macro actions around, or copy macro actions to the macro you're modifying or to another macro.
Inserting New Macro Actions
To insert a macro action, follow these steps:
Click the line above where you want to insert the macro action. Press Insert, click the Insert Rows button on the toolbar, or choose Insert | Rows. Access inserts a new line in the macro at the cursor.
To insert multiple macro actions, follow these steps:
Place the cursor on the line above where you want Access to insert the new macro action lines. Click the Macro Action Selector, which is the gray box to the left of the macro's Action column. Click and drag to select the same number of Macro Action Selectors as the number of macro actions you want to insert. Press the Insert key, click the Insert Rows button on the toolbar, or choose Insert | Rows. Access inserts all the new macro lines above the macro actions that you selected.
Deleting Macro Actions
Follow these steps to delete a macro action:
Click the Macro Action Selector of the macro action you want to delete. Press the Delete key, click Delete Rows on the toolbar, or choose Edit | Delete Rows.
Follow these steps to delete multiple macro actions (macros):
Click and drag to select the Macro Action Selectors of all the macro actions you want to delete. All the macro actions should be highlighted in black. (See Figure 13.15.)
Press the Delete key, click Delete Rows, or choose Edit | Delete Rows.
Moving Macro Actions
You can move macro actions in a few ways, including by dragging and dropping and by cutting and pasting.
To move macro actions by dragging and dropping, follow these steps:
Click and drag to select the macro action(s) you want to move. Release the mouse button. Place the mouse cursor over the Macro Action Selector of any of the selected macro actions. Click and drag. A black line appears, indicating where Access will move the selected macro actions. Release the mouse button. Access inserts the macro actions where you release the mouse button.
 | If you accidentally drag and drop the selected macro actions to an incorrect place, you can use the Undo button on the Macro Design toolbar or choose Edit | Undo to reverse the action. |
To move macro actions by cutting and pasting, follow these steps:
Click and drag to select the Macro Action Selectors of the macro actions you want to move. Click Cut on the Macro Design toolbar (or use Ctrl+X). Click the line above where you want Access to insert the cut macro actions. Don't click the Macro Action Selector. Click Paste. Access inserts the macro actions at the cursor.
 | Don't click the Macro Action Selector of the row where you want to insert the cut macro actions, unless you want to overwrite the macro action you have selected. If you don't click to select the Macro Action Selectors, Access inserts the cut lines into the macro, without overwriting any other macro actions; if you click to select Macro Action Selectors, Access overwrites existing macro actions. |
Copying Macro Actions
You can copy macro actions within a macro or to another macro.
Follow these steps to copy macro actions within a macro:
Click and drag to select the Macro Action Selectors of the macro actions you want to copy. Click Copy on the Macro Design toolbar (or use Ctrl+C). Click the line above where you want to insert the copied macro actions. Don't click any Macro Action Selectors unless you want to overwrite existing macro actions. (See the Caution preceding this section.) Click Paste. Access inserts the macro actions you copied at the cursor.
Follow these steps to copy macro actions to another macro:
Click and drag to select the Macro Action Selectors of the macro actions you want to copy. Click Copy on the Macro Design toolbar (or use Ctrl+C). Open the macro that will include the copied actions. Click the line above where you want to insert the copied macro actions. Click Paste. Access inserts the macro actions you copied at the cursor.
|
