I have the report setup to print on a specific printer.
It's been working fine for months, then all of a sudden yesterday it printed on our mono machine instead of our colour one. Which meant I had to go into the queries and reset the ones that had been updated.
When I opened the report in design view and it said the specific printer was unavailable, so I reselected it (exactly the same IP, name, everything), saved and it ran fine.
This morning, same thing happened again!
I can't have this happening every day so I'm wondering if there's any VBA I can add to the onPage event to make sure it selects the right printer?
Thanks
Mandi
Edit:
I just found this code:
Expand|Select|Wrap|Line Numbers
- reports(0).Printer.devicename = "My Printer"