different printers

  • Thread starter Thread starter Lapchien
  • Start date Start date
L

Lapchien

I have 10 reports and 10 printers. Each report is required to print to any
of the 10 network printers. These 10 printers are in 'Areas'. So, I may
have Report 1 that needs to be printed to Area 1, or Area 4, or Area 9,
depends on what is entered in the 'Area' Field on the record. How can I
achieve this..?

Thanks,
Lap
 
Let the user preview the report.
From the Print item on the File menu, they can select their printer.

If you want to do it programmatically, in Access 2002 and later, there is a
Printer object. You can examine the Printers collection, and assign a
Printer.

For earlier versions, follow this link:
http://www.mvps.org/access/reports/rpt0009.htm
 
Thanks. The way we use the database, in a buys call centre, means that the
users would not be able to select the printers manually...
 
Sure, the just built some tables with the option, and also in that table you
could put the printer name.

Then, just use my code to set the printer....
 
Back
Top