LillyC
asked on
Can I set eports to print double-sided in Access 2010
Hello
Anyone know how I can set my reports to print double-sided?
Anyone know how I can set my reports to print double-sided?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<No Points wanted>
Code here will list your installed Printers:
https://msdn.microsoft.com/en-us/library/office/ff835733.aspx
Code here will list your installed Printers:
https://msdn.microsoft.com/en-us/library/office/ff835733.aspx
ASKER
Thank you.
As commented above, an easy approach, with printers that support it, is to set Page properties to double sided, automatic or manual.
In case there is a urgent requirement to print, say odd or even pages, then some VBA code may achieve that.
The code works by first sequencing the records eligible for printing, then calls the report with the odd numbers, then with even numbers. A pause is set to allow for reversing paper.
In case there is a urgent requirement to print, say odd or even pages, then some VBA code may achieve that.
The code works by first sequencing the records eligible for printing, then calls the report with the odd numbers, then with even numbers. A pause is set to allow for reversing paper.
Dim prt As Application.Printer
Set prt = Application.Printers("Name
prt.Duplex = acPRDPHorizontal
Now try printing your report.
If your report uses a specific printer, you'll have to get that Printer in the "Set prt" line.
See this article: https://msdn.microsoft.com/en-us/library/office/ff198051.aspx
Note too that "NameOfYourPrinter" is the name that VBA recognizes, which may be different than the name shown in Windows. You may need the user to verify which printer will be used before doing something like this.