My Assistant
![]() ![]() |
|
|
Mar 23 2012, 11:13 AM
Post
#1
|
|
|
UtterAccess Guru Posts: 513 |
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 |
|
|
|
Mar 23 2012, 11:27 AM
Post
#2
|
|
|
UtterAccess Guru Posts: 513 |
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 |
|
|
|
Mar 23 2012, 12:05 PM
Post
#3
|
|
|
UtterAccess Guru Posts: 513 |
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 ? |
|
|
|
Mar 27 2012, 09:01 AM
Post
#4
|
|
|
UtterAccess Guru Posts: 513 |
I still can not find a solution to this. Has anyone expirienced a similar problem ?
|
|
|
|
Mar 28 2012, 06:08 AM
Post
#5
|
|
|
UtterAccess Guru Posts: 513 |
I start to wonder if anything wrong with my question as no one has answered yet, which is quite unusual on this site.
|
|
|
|
![]() ![]() |
|
Go to Top · Lo-Fi Version | Time is now: 18th May 2013 - 05:54 AM |