Printing 2 repors double sided (1 Viewer)

[JamesN]

Hi,

I have a database which has 2 different reports (Print Form and PrintForm2) They are printed via a button in a form (code below)

DoCmd.OpenReport "PrintForm", acViewReport
DoCmd.PrintOut
DoCmd.close acReport, "PrintForm"
DoCmd.OpenReport "PrintForm2", acViewReport
DoCmd.PrintOut
DoCmd.close acReport, "PrintForm2"

Currenltly they are printing one sided on two different sheets. Is it possible to add code to print both reports as double sided on one sheet?

Thanks

James

 

[Ranman256]

In control panel, set the printer property to print duplex.
Then run the report.

 

[JamesN]

Checked in control panel and it is set to double sided in settings. Does the VBA need amending?

 

[Ranman256]

it shouldnt. Unless you stuck some page break controls into the report.
BUT in the report design, set it in the report,
click Page setup,
page tab,
use specific printer,
set the property of the printer to DUPLEX.

 

[HiTechCoach]

Hi,

I have a database which has 2 different reports (Print Form and PrintForm2) They are printed via a button in a form (code below)

DoCmd.OpenReport "PrintForm", acViewReport
DoCmd.PrintOut
DoCmd.close acReport, "PrintForm"
DoCmd.OpenReport "PrintForm2", acViewReport
DoCmd.PrintOut
DoCmd.close acReport, "PrintForm2"

Currenltly they are printing one sided on two different sheets. Is it possible to add code to print both reports as double sided on one sheet?

Thanks

James

James,

Each print job start on the front side of the page.

Since are sending two print jobs, they each start on the front side.

You need some way to combine the two report into a single multiple page print job. That way the printer can print it full duplex (front end back).

The simplest method is to combine the two reports into a single report. This may be as easy as add the second report as a sub report to the first report's Report Footer section.

If the report can't be combined, another option is to save them both to a PDF and then combine them together before printing.