Hope someone can tell me if this is possible and if so how to make it happen.
I have a 2 page report in my DB that is printed by a button on a menu within the DB.
The folks that utilize the DB would like this report to print double sided instead of on 2 seperate sheets of paper. Our printers are cablable of double siding anything if you tell them to. However is there soemthing I can do so that whent he button is clicked and the report is generated it will automatically double side the report rather then the user having to View the Report first and then going into the printer properties and selecting Double Sided?
We are using Ricoh Copy machines as Printers in my company.
Thanks, however that is the opposite of what I am trying to accomplish. My report is only 2 pages long every time. It prints on 2 pages and I want it to duplex on 1 sheet of paper for the user instead of 2 seperate pages.
That was air code. I don't have a printer to test it. The code does allow for what your printer is set to as the default print method.Sorry for the confusion. In the middle of some very difficult coding myself here. Use the code (As Is) on the OnOpenEvent of your Report.Test to see if it will work for you.
I was wrong when I suggested that! Need another cup of coffee! Just use the code as is. No Report name necessary! The code sets the report to your Printer settings. I can't test it for you, so this is as far as I can go.
Dim rptReport As Report
Set rptReport = Reports(strReport)
If rptYourReportName.Printer.Orientation = acPRORLandscape Then
rptYourReportName.Printer.Duplex = acPRDPVertical
rptYourReportName.Printer.Duplex = acPRDPHorizontal
This code is supposed to open your report from some command button or code.
Unless you post a sample db, I'm afraid I can't help anymore. And I don't have a double sided printer to test the code.
Good Luck With Your Project.