Software

Create a macro for printing multiple Access reports

Did you know that you can create a macro to print a number of Access reports all at once? Mary Ann Richardson shows you the steps.

When you need to print a number of Access reports, you can create a macro to print them all at once. To do so, follow these steps:

  1. Open the database containing the reports.
  2. Click Macros Under Objects in the Database window.
  3. Click New.
  4. Resize the Macro1:Macro window and position it alongside the Database window.
  5. Click Reports Under Objects.
  6. Click and drag the name of the first report you want to print to the first cell under Action.
  7. Click and drag the name of the next report you want to print to the next empty cell under Action.
  8. Repeat step 7 until you've dragged all the reports to the Macro1:Macro window.
  9. Close and save the macro.
  10. Click Run to print out the reports.

Now that you have saved the macro, you can have Access print these reports again at any time.

Miss an Access tip?

Check out the Microsoft Access archive, and catch up on other Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks