I am trying to print the 2 pages report.
The 1st page comes out from Tray 1 - single-sided.
The 2nd page comes out from Tray 2 also single-sided (but want to print duplex)
The reason I need only second page duplex print is the that the paper has different header on it and by default it prints single-sided.
My testing code is:
CODE
DoCmd.OpenReport reportName, acViewPreview, , "WHERE STRING"
reports(reportName).Printer.PaperBin = Tray1
DoCmd.PrintOut acPages, 1, 1
DoCmd.close acReport, reportName
reports(reportName).Printer.Duplex = acPRDPHorizontal
reports(reportName).Printer.PaperBin = Tray2
DoCmd.PrintOut acPages, 2, 999
DoCmd.close acReport, reportName
reports(reportName).Printer.PaperBin = Tray1
DoCmd.PrintOut acPages, 1, 1
DoCmd.close acReport, reportName
reports(reportName).Printer.Duplex = acPRDPHorizontal
reports(reportName).Printer.PaperBin = Tray2
DoCmd.PrintOut acPages, 2, 999
DoCmd.close acReport, reportName
The Trays work fine. But the second page never prints as duplex. I've tried acPRDPHorizontal, acPRDPVertical and acPRDPSimplex, but still print on the same wrong side.
The report is set to default in page setup.
Does anyone knows what am I missing ?
Thanks