tvae
asked on
Force to print report on single side in access
I have a form command button to print a report and even thought the printer seting is single side print it still print duplex when clicking the button. The command is as below.
DoCmd.OpenReport "reportname", acViewNormal
I dont see anywhere why it should print doeble sided, Is there a code to force it as single sided?
ASKER
Yes using access 2002. The printer is set to single but dont know why it's printing double sided
ASKER
I have added this rule but still print duplex.
Dim rpt As Report
Dim prtnew As Printer
DoCmd.OpenReport ReportName:="rptPickListAL LPONumber" , View:=acViewNormal
'stDocName = "rptPickListALLPONumber"
Set rpt = Reports!rptPickListALLPONu mber
Set prtnew = rpt.Printer
prtnew.Duplex = acPRDPSimplex
Dim rpt As Report
Dim prtnew As Printer
DoCmd.OpenReport ReportName:="rptPickListAL
'stDocName = "rptPickListALLPONumber"
Set rpt = Reports!rptPickListALLPONu
Set prtnew = rpt.Printer
prtnew.Duplex = acPRDPSimplex
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
^ oh and if you ty this, use the simple code to open the report:
DoCmd.OpenReport "reportname", acViewNormal
DoCmd.OpenReport "reportname", acViewNormal
ASKER
omg..that was it.
;-)
What version of Access are you using? Access 2002+ exposes the Printer object, which you may be able to use:
http://msdn.microsoft.com/en-us/library/aa139946(office.10).aspx