Full Version: Printing Duplex From Page 2
UtterAccess Discussion Forums > Microsoft® Access > Access Reports
AlexTeslin
Hi,

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


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
AlexTeslin
After doing further tests I found that it doesn't really matter what page number the report prints.

I've tried with only one page with the following line and without, but prints on the same side in both cases.

reports(reportName).Printer.Duplex = acPRDPHorizontal

I really don't know where else to look
AlexTeslin
Another interesting thing I found that it works on Brother printer, but it does not work on HP LaserJetP4015x.

I am trying to find if anything to do with acPRDPHorizontal constants. Perhaps HP printer uses different constants ?
AlexTeslin
I still can not find a solution to this. Has anyone expirienced a similar problem ?
AlexTeslin
I start to wonder if anything wrong with my question as no one has answered yet, which is quite unusual on this site.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.