Hi,
I have several reports that print to a special label printer that is not set as the default printer. I wish to automaticly set the print settings to the label printer for when I need to print to it but not change the system default printer.
Basiclly select the printer and the paper size.

Hope someone can help

Gezza

In the Page setup, select the desired printer instead of the default printer (which is the default).

There are a number of different programs running of the same computer each needs a different printer or settings. These are located on a factory shop floor I would rather be able to set the printer settings according to the program needs automaticly.
I have found some code that allows me to change the printer but not the Pages settings at this stage.

Dim prt As Printer
Set prt = Application.Printers("Smart Label Printer 440")
Set Application.Printer = prt
"then to turn it back"
Application.Printer = Nothing

I am hoping to be able to change the page settings also

The printer settings are unique to the label. Remember if you are using this on many machines and the Smart Label printer is slaved of the com port then make sure that they all share the name. As per what appears under the icon in the print manager window.

When you nominate that printer Access looks for that name and not its proprietory name.

David

Install another instance of the printer with a different name and save the settings you require. Take away the permissions that enable ordinary users to change anything.

This is also useful on printers with multiple paper trays. Install the printer multiple times with the tray set to the one required and a name that indicates this. It saves having to go into the printer properties each time to select the desired tray.

BTW. For those who have not encountered it, you can install printers on a server and "push" the share out to the clients via group policy.