Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem selecting paperbin

Status
Not open for further replies.

lizray

Programmer
May 14, 2008
126
AU
I want to print stickers and be able to select the paperbin. When I use a printer with a paperbin value of <255 it seems to work, but unfortunately some of my printers have bin a value > 255, i.e. 261 and this simply seems to be rejected and the default bin (xx=263) is used. Here is the code:

strReport = "rptStickers"
DoCmd.OpenReport strReport, acViewPreview, , , acHidden
With Reports(strReport)
Set .Printer = Application.Printers(cboPrinters.Column(0))
End With
With Reports(strReport).Printer
.PaperBin = cboBins.Column(1)
xx = .PaperBin
Stop
end with

the xx is for debug purposes to let me know what bin the printer has decided to use.
I am using Access 2002, Has anyone else experienced this ?
 
Solved it !! I needed the Service pack 3 and all works well
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top