Chnage Default Printer for Report

D

Domenick

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

Domenick

WOW! That was simple! Thanks for your help. It was just one of those things
that was bugging me. :)
 
Top