Access Reports and Printer Definition

[MushroomBill]

I've already mentioned on here that I'm working on a project to move a number of access databases to a new server. Thanks to those that responded last time.

I've just been told that there 50-60 reports in the project that are sent to 5 or 6 specific printers. The printers are also on the move and will be given new IP addresses and names.

Is there are way of programmatically changing the report definition to modify the printer?

Sadly "Reports("rptName").Printer.DeviceName", ".Port" and "Driver" all seem to be read only.

Anybody know how to do this?

Any help appreciated.

Thanks again

Bill

 

[genomon]

Starting with Access 2002 there is a new printer object that will do what you want. If you use this version or later, do a help search on "printer object"; also there is a great article in MSDN called "Programming Printer Settings in Microsoft Access 2002" along with a dwonloadable sample .mdb.

Outside of a dog, a book is man's best friend. Inside of a dog it's too dark to read.