Software

Create a command button to print multiple copies of an Access report

If you often need to print out the same number of Access report copies, Mary Ann Richardson explains how you can create a command button that will print the copies for you.

You often need to print five copies of an Access report for meetings. To save time, you can create a command button that will print the copies for you. Follow these steps:

  1. Open a new form in Design view.
  2. Click the Command Button tool in the Toolbox.
  3. Click and drag in the form where you want the tool.
  4. Click Cancel to close the Command Button wizard if necessary.
  5. Right-click the command button and select Properties.
  6. Click in the Caption property box under the All tab and enter Print Employee Report.
  7. Click the Event tab and click the On-Click property box.
  8. Select [Event Procedure] from the drop-down list.
  9. Click the Build button.
  10. Enter the following code at the prompt:

DoCmd.SelectObject acReport, "Employees", True
DoCmd.Printout ,,,,5

  1. Press [Alt]Q.

Now when you need to print outĀ five copies, simply click the Print Employee Report command button in your form.

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