Access 2007 wont save specific printer

Posted on 2007-10-18
Last Modified: 2013-11-28
Access 2007 wont save specific printer. I think its a bug with 2007 and I wish I wouldnt have upgraded but to late now. How do I get around this. Here is the VB code for the button that I want to automaticly print 3 reports:

Private Sub Command162_DblClick(Cancel As Integer)

  Dim stDocBOADeposit55 As String
    stDocBOADeposit55 = "US Deposit Page 1"
    DoCmd.OpenReport stDocBOADeposit55, acNormal
     Dim stDocBOADeposit56 As String
    stDocBOADeposit56 = "US Deposit Page 2"
    DoCmd.OpenReport stDocBOADeposit56, acNormal

     Dim stDocBOADeposit57 As String
    stDocBOADeposit57 = "US Deposit Page 3"
    DoCmd.OpenReport stDocBOADeposit57, acNormal

End Sub

Is it best to change default printer to what I want and then back? Can I choose the printer with VB? What is the best work around. havent had much traning in VB so the more you can explain the better. Thanks much.

P.S. If I ever see Bill Gates I will kick him in the nutts for this.
Question by:stevepletan
    LVL 3

    Expert Comment

    By clicking on the office button and then selecting the print option you should see three options. Print, Qiuck Print, Print Preview. If you select Print it gives to choose which printer you want to print to. Now access will normally print to your default printer but if you select a different printer in the dialog box that is the printer it should use when selecting Quick Print. At least that is how it works on our machines.


    Author Comment

    I want the printer saved. I do not want to choose the right printer evey time I print.
    LVL 3

    Accepted Solution

    Once you have selected a printer for the particular report that report should use that printer on that machine unit you reset it by selecting a different printer. If you do not select a printer it will always print to the default print. If this is not happening  on your computers then there may be a need to check the system setting in access.

    LVL 1

    Expert Comment

    Forced accept.

    EE Admin

    Expert Comment


    I too had this problem and managed to solve it....  I thought I would post it here so that other people might be able to use it.

    I found that if you have the printer you want to print to set to default, then go into design mode, then go to the print preview of the report.  Once in print preview go to print settings assign the specific printer and print options you require.  If you then save from here the report doesnt lose its settings.  You are then able to have any printer set to default and it will still send it to the specific printer you chose.  Be aware though anytime you then go back into design mode you will have to reapply print settings as before.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Suggested Solutions

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    737 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

    20 Experts available now in Live!

    Get 1:1 Help Now