Duplex Printing Access2002/WinXP

D

Dan Butler

I'm having trouble getting Access 2002 to print reports in duplex mode
from a VB6 application running on WinXP.

- The printer is duplex enabled (Sharp AR-280/PCL6)
- I tried setting the report print properties from within Access
by accessing the Printer Prefs Dialog from PrintView/Page/SpecificPrinter
- I tried setting the ReportPrintPrefs to default printer and using the
following code:
Set appAccess = New Access.Application
appAccess.Printer.Duplex = acPRDPHorizontal
appAccess.OpenCurrentDatabase ReportsDbName
appAccess.DoCmd.OpenReport "rptLotActivity", acViewNormal, ,
WhereClause, acWindowNormal
appAccess.DoCmd.Close
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplex Printing VBA Code 0
duplex printing - double-sided printing 1
Printing multiple duplex copies with Publisher 2003 2

Top