UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Printing Duplex From Page 2, Office 2003    
 
   
AlexTeslin
post Mar 23 2012, 11:13 AM
Post #1

UtterAccess Guru
Posts: 514



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
Go to the top of the page
 
+
AlexTeslin
post Mar 23 2012, 11:27 AM
Post #2

UtterAccess Guru
Posts: 514



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
Go to the top of the page
 
+
AlexTeslin
post Mar 23 2012, 12:05 PM
Post #3

UtterAccess Guru
Posts: 514



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 ?
Go to the top of the page
 
+
AlexTeslin
post Mar 27 2012, 09:01 AM
Post #4

UtterAccess Guru
Posts: 514



I still can not find a solution to this. Has anyone expirienced a similar problem ?
Go to the top of the page
 
+
AlexTeslin
post Mar 28 2012, 06:08 AM
Post #5

UtterAccess Guru
Posts: 514



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 the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 24th May 2013 - 01:51 PM