Setting printer properties

J

Jackster

When I run the follow code to print the "Envelope" report it overrides the
page setup settings for this report and pulls paper from the default bin and
not from the manual feed as I have saved it. I know I need to use the
PaperBin property setting but I can't figure out where it goes in the code
below. Help!

Dim RptName As String
RptName = "Envelope"

DoCmd.OpenReport RptName, View:=acPreview, WindowMode:=acHidden

With Reports(RptName)
Set .Printer = Application.Printers(cboDestination.ListIndex)
'cboDestination.ListIndex is a listing of printers installed on the user's PC
End With

DoCmd.OpenReport RptName, View:=acViewNormal
DoCmd.Close acReport, RptName, acSaveNo
 

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

PaperSize 15
Setting printer properties 0
Str where and muliple criteria problem 11
Close Report & Database in an External DB (not in the Current Data 3
Suggestions Needed: Printing PDFs Using Acrobat 8 2
Can't get the code to sort the data properly. 1
How do I assign a name to a PDF report via VBA 3
Change report printer destination using code 5

Top