Setting specific printer in design of reports - Is there a quicker way?

[Axworthy]

Here is my problem. The client want these 3 reports to default to this printer, these 12 reports to go to that printer and these 4 label reports to go to the label printer. Sooner or later they get some new printers and want them all defaulting to other printers.

To do that, I have to go into the design of each report, page setup, page tab, specific printer, pick the printer, save and go on to the next report. Is there a utility out there that I can use that will list my reports in the database, allow setting the printer for each and then have it change the design of the report for me? I am just looking for a way to save me some time and a whole bunch of mouse clicks.

 

[sxschech]

I'm not at my regular computer today, but I think you can change the printer settings with vba. Perhaps you could create a table with the report name and printer that way if in the future the user wants to change the printer for a particular report or set of reports they only have to change the printer name in the table and then the vba code would choose the printer accordingly.

 

[LaurieHamlin]

The exact code depends on which version of Access you're using.

 

[Axworthy]

Laurie,

I develop in Access 2003 mostly. Clients use 2007, 2010 and the one that I most want to do this on uses 2013.