Chnage Default Printer for Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access report that our company has been using for years. It was
designed by one of my predecessors. It is scheduled to run from a macro
Dim stDocName As String

stDocName = "rpt_active plaza cash back"
DoCmd.OpenReport stDocName, acNormal
Everytime it runs, I get an error that the report was originally formatted
for a printer that no longer exists on our network. I can easily switch to
the new printer from the dialog, but the goal is for this report to run
unattended.

How do I get the report to recognize the new printer as the default and
forget about the printer it was created with?

Thanks, Domenick (Access 2003)
 
1. Open the report in Design view.

2. Choose Page Setup from the File menu.

3. On the middle tab, choose:
Default Printer.

4. Close the dialog, and save the report.
 
WOW! That was simple! Thanks for your help. It was just one of those things
that was bugging me. :)
 

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

Printer Dialog 4
Multiple Reports to use only 1 Query 1
Access Change My Default Printer 1
Autonaming a PDF report? 1
Filtering a report by controls 4
Print Reports and Sub Reports 7
Send Reports based on Query to Printer Automatically 5
Stop print more than one copy of a report 1

Back
Top