Chnage Default Printer for Report

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)
 
A

Allen Browne

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.
 
G

Guest

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

Top