[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


How to print Access 2010 report to printer

Posted on 2012-09-04
Medium Priority
Last Modified: 2012-09-13
Hello, I have multiple reports that I would like to print to my printer, one after the other via vba.  Can someone provide sample script.  Thank you.

Question by:ilfocorp
  • 2
LVL 61

Accepted Solution

mbizup earned 600 total points
ID: 38365367
Opening a report in normal view will automatically send it to the default printer:

Docmd.OpenReport "rpt1"
Docmd.OpenReport "rpt2"
Docmd.OpenReport "rpt3"

Open in new window


Author Comment

ID: 38365437
I've requested that this question be deleted for the following reason:

question resolved
LVL 61

Expert Comment

ID: 38365438
Did you hit the delete button intentionally?

What I posted is a valid way to print reports successively.

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question