Microsoft Access Programmer Salt Lake City Utah

Microsoft Access Programmer Information

Call MS Access Solutions at (323) 285-0939 For Complimentary Consultation

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. First, you must enter Design view for the macro:

1.Select the Macros group on the Navigation Pane.

2.Select the macro you want to modify.

3.Right-click and select Design View.

When the design of the macro appears, you're then ready to 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:

1.Click on the line above where you want the macro action to be inserted.

2.Press your Insert key or click Insert Rows in the Rows group on the Design tab. A new line is inserted in the macro at the cursor.

To insert multiple macro actions, follow these steps:

1.Place your cursor on the line above where you want the new macro action lines to be inserted.

2.Click and drag on the Macro Action Selector (the gray box to the left of the macro's Action column) to select the same number of Macro Action Selectors as the number of macro actions you want to insert.

3.Press the Insert key or click Insert Rows in the Rows group on the Design tab. All the new macro lines are inserted above the macro actions that were selected.

Deleting Macro Actions

Follow these steps to delete a macro action:

1.Click on the Macro Action Selector of the macro action you want to delete.

2.Press the Delete key or click Delete Rows in the Rows group on the Design tab.

Follow these steps to delete multiple macro actions:

1.Click and drag to select the Macro Action Selectors of all the macro actions you want to delete. All the macro actions should be surrounded by a box.

2.Press the Delete key or click Delete Rows in the Rows group on the Design tab.

Moving Macro Actions

You can move macro actions in a few ways, including dragging and dropping and cutting and pasting. To move macro actions by dragging and dropping, follow these steps:

1.Click and drag to select the macro action(s) you want to move.

2.Release the mouse button.

3.Place your mouse cursor over the Macro Action Selector of any of the selected macro actions.

4.Click and drag. A line appears, indicating where the selected macro actions will be moved.

5.Release the mouse button.

To move macro actions by cutting and pasting, follow these steps:

1.Click and drag to select the Macro Action Selectors of the macro actions you want to move.

2.Click Cut in the Clipboard group on the Home tab or press Ctrl+X.

3.Click in the line above where you want the cut macro actions to be inserted. Don't click the Macro Action Selector.

4.Click Paste in the Clipboard group on the Design tab. The macro actions you cut are inserted at the cursor.

This material originally appeared in Alison Balter's book Mastering Microsoft Office Access 2007 Development. Reprinted here by author's permission.

When you need a Microsoft Access programmer for your Salt Lake City UT business, call MS Access Solutions at (323) 285-0939. We have over 25 years experience in Microsoft Access programmer solutions. We create Access database applications for all sectors, consisting of hospitals, government agencies, the U.S. military, universities, agriculture, workers services, and insurance provider. We can take care of the most advanced as well as complicated Access and also SQL Server database programming for your business as well as smaller projects, like fixing damaged Access database forms, MS Access reports, Access macros, and VBA code.

More Access programmer cities we serve: Access Programmer Arlington VA