How to print Access 2010 report to printer

Posted on 2012-09-04
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
    LVL 61

    Accepted Solution

    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

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

    question resolved
    LVL 61

    Expert Comment

    Did you hit the delete button intentionally?

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

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now