how to get printer name from PrtDevMode

[nickjar2]

I am using the PrtDevMode property to turn duplex printing on or off depending on whether the user has the duplex facility.

I need a way of using this property to change the printer for all reports. I will explain with an example:

I have developed a system that prints out various reports. I have created the reports at my base, but need other offices to use this database. At the moment, as soon as they get a new version, they have to open each report in designmode, and re-choose their specific printer (this is because obviously we all have different printers 'cause we are in diff offices) and save it, otherwise it looks for my printer which is only available to my office.

What i would like is on the main menu, to have a combo box which displays all the available printers. The first time a user uses the db, they will need to select a printer that they wish to use from the combo. Once this is done, my code will update all reports to point to this printer. Next time they open the database, they won't need to worry about choosing a printer, because he code i have will already have saved the printer with all the reports.

If this hasn't made sense, plz let me know, and i will try again. Hope this is ok. If not, just let me know.

Nick (Everton Rool OK!)

 

[THoey]

Makes sense. Do you have the Access 97 Developer's Handbook or the Access 2000 Developer's Handbook? It has code on the CD that does something like this. If not, I am sure someone here will have an idea... Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...