printig report

J

JIM.H.

Hello,
With the following code, I am trying to set my default
printer and print the report and set the original printer
back as default. However myReport is not printed to the
printer I set, it is printing to another printer I have.

' get current default printer.
strDefaultPrinter = Application.Printer.DeviceName
' switch to printer
Set Application.Printer = Application.Printers
("myPrinter")
' print recalls
stDocName = "myReport"
DoCmd.OpenReport stDocName, acNormal
' switch vack to default printer
Set Application.Printer = Application.Printers
(strDefaultPrinter)

What is problem,
Thanks,
Jim.
 

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

View & Print Report from Form's Command Button using Lexmark Printer 1
Access Change My Default Printer 1
PDF Toolbar Button 4
Filter a function that runs a report as a pdf (RunReportAsPDF) 0
OS dependant code 1
Error handler 3
Printer change code 0
Access change My Default Printer for All the Reports 4

Top