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
.
.
.
David_W_RAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
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.
0
David_W_RAuthor Commented:
So then how do I specify which reports are to be printed on which side of each page?
0
David_W_RAuthor Commented:
...or do I just print blank pages between reports that are to be blank on the back?
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

David_W_RAuthor Commented:
Can I specify "double-sided" in the code, then have it revert when I am finished to single-sided?
0
Jeffrey CoachmanMIS LiasonCommented:
<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
0
David_W_RAuthor Commented:
A couple of days.   It's just that I don't have time to figure it out.
0
Jeffrey CoachmanMIS LiasonCommented:
So what about the separate report option?
0
David_W_RAuthor Commented:
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.
0
Jeffrey CoachmanMIS LiasonCommented:
Then there is really no easy way to do this...
Then only thing I would suggest is that you combine 1 and 5 together as one report.

Lets see if another expert is willing to dig deeper...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.