Set different printer in a report

J

jimt

I have a report using a that I would like to sent to one of two printers
based on a a field within the record read. A query is used as the data source
for the report and the printer control data is a Yes/No field. If the yes/no
field is "yes" I want to send the print out for the record to go to printer
"A" and if the value is "no" sent the record print out to printer "B". This
is a local DB and the two printer are attached to the PC containing the DB.

Is there a way to dynamically switch printers based on the record during the
running of the report? For example including a function on detail in the
report to set the printer. If so what are the command(s)?

Thanks
Jim T.
 
J

Jeff Boyce

Jim

Which version of Access? Access 2007 has some limitations on using a
"designated" printer rather than the default printer.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

jimt

The DB is an Access-2000.

Thanks
Jim T

Jeff Boyce said:
Jim

Which version of Access? Access 2007 has some limitations on using a
"designated" printer rather than the default printer.

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Epson Printer Problem 6
List of Printers 2
Printer Selection for access printing 1
Set Printer for 1 Particular Report 1
specific printer 1
Print each report to a different printer tray: Access 2003 1
ATTAC "On the Fly printing" prints only to default printer regardless of printer chosen in print dia 2
Imbed a word doc in a report 2

Top