Printing Reports to a specific printer

[i1055]

I have a simple macro that prints a report, however it prints to the default printer and I would like it to print to a specific printer. I have gone into the page setup of the report and changed the printer to the specific printer that I want, saved the report etc. and it prints to the printer I specified. However, when I print it again the next day, it reverts back to printing at the default printer. <br>
<br>
Any ideas?<br>
<br>

 

[DougP]

1. Open the report in design view<br>
2. Click &quot;File&quot; Menu<br>
3. click &quot;Page Setup&quot;<br>
4. click the &quot;Page&quot; TAB<br>
5. click Specific printer (at the bottom)<br>
Note: The Printer has to be one this computer is already connected to (if you clcik Start, Settings, Printers)<br>
6. Choose the printer<br>
7. click &quot;File&quot; menu<br>
8. click &quot;Save&quot;<br>
<br>
thats it<br>
Print it out

 

[i1055]

i have done exactly what you said, but for some reason the next day everything reverts back to the default printer.

 

[DougP]

Is more than one person opening the database?<br>
If someone else has the database open when you are making a change then their copy may over-wright your newly saved copy.<br>
Get everyone out.<br>
and try it again.<br>
Then make a backup copy of the new changes<br>
In explorer fing the .MDB Press Ctrl-C then Ctrl-V <br>
It will make a &quot;Copy of Your MDB&quot;<br>
<br>
<br>