Link to home
Start Free TrialLog in
Avatar of David_W_R
David_W_R

asked on

How to print double sided on only one page of a report

I'm starting with a 5-page quarterly report that works perfectly.   I want to make a change to print one page double-sided.  Time constraints bring me here to quickly make this work.  I need to know how to code the process to print what was previously printed on pages 1 and 5 to instead print what was on page 5 on the back of page 1.

Currently, code includes:

.
.
.
DoCmd.OpenReport "rpqtr-title page", acViewPreview, , "HHID = " & ClientNowPrinting
DoCmd.PrintOut acPages, 2, 2
.
.
.
DoCmd.OpenReport "rpQtr-Glossary", acViewPreview, , "HHID = " & ClientNowPrinting
DoCmd.PrintOut acPrintAll, 2, 2, acHigh
.
.
.
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Are you trying to do this on a true "Duplex" (double-sided) capable printer?
If so, then you can just set this printer as the default printer, then set the printer properties (or Options) to print double-sided.
Each printer may have a slightly different way to do this, so check your printers documentation.
Avatar of David_W_R
David_W_R

ASKER

So then how do I specify which reports are to be printed on which side of each page?
...or do I just print blank pages between reports that are to be blank on the back?
Can I specify "double-sided" in the code, then have it revert when I am finished to single-sided?
<I'm starting with a 5-page quarterly report that works perfectly.   I want to make a change to print one page double-sided. >
This cannot be done directly
When you click "Print", the printer setting will be for the entire report.

< Time constraints bring me here to quickly make this work.>
So the "quick" answer is that you can't do this.

If you are strapped for time, then please state exactly when you need a solution by...
...as Experts may not want to invest the time to write something custom, only to be told that "Oh, sorry, I needed this by 12 Noon NY time."

I can see this being done perhaps by creating the two pages (that need to be double sided) as one report.

JeffCoachman
A couple of days.   It's just that I don't have time to figure it out.
So what about the separate report option?
Actually, each page is a separate report now.   I have 150 report "sets" to print, and need to have them collated as they print.  I print each page in sequence to produce one report for a client.  I need to combine two of the pages by printing double-sided what used to be page 1 and page 5.

It boils down to how to print pages 2 thru 4, each with a blank backside, followed by page 1 and 5 on the front and back of the same sheet, double-sided.  Then this same sequence needs to be repeated for 150 clients.

Again, each of pages 1 thru 5 are already individual Access objects.
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial