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.

5 comments
alirezahusainy
alirezahusainy

Thank you from this tips. I want to ask that how can we print a page in Visual Basic?

sxviswan
sxviswan

This could have been a tip for creating any macro in Access.

john.nealis
john.nealis

How do you set your default Access printer to the PDF writer? I want to write a macro to print a list of reports to PDF files

ssharkins
ssharkins

In the Visual Basic Editor, search the Help file for "PrintOut" method. If you need more help, check back in.

Editor's Picks