Labels - configure printer via vba

[Mgomp]

Hi all.

In my app I have several reports, and some labels.
My colleges which are running my app does all want to be able to select a separate printer for one of the labels, or the posibilty to select a specific printer / tray for some of the reports/labels.
What I need is the posibility to select a report / label and then activate the Page Setup for that report for selecting printer / tray. And the save the setup.
The point is to avoid to let the users open the navigation pane, and use design view on the report / label for getting the Page Setup.

Anyone with a good idea?

 

[HiTechCoach]

See: Programming Printer Settings in Microsoft Access 2002

*Note: Applies to Access 2002-2010.

 

[Mgomp]

Hi there, HiTechCoach

Thank you! This is an absolute perfect solution! It's exactly what I am looking for.

Have a nice day.

Regards

 

[HiTechCoach]

You're welcome.

Glad we could assist.