Sending to two different printers

[rzkl]

Hello,
I have a database I'm designing that will be used to print pallet tags. I have two different printers that will be printing them that are located a fair distance apart.
I have a table setup with product descriptions and all the information that will print on the tags, in that table I have a field called printer,in that field is either a "1" or a "2" that determines what printer that tag should print to.

I have two identical reports setup report1 and report2, each of them has a different printer set to them

What I was trying to do is run a query and based on the value of that printer field either run report 1 or 2

I have tried to do this whin a macro but due to my limited knowledge I'm stuck

Im pretty new to Access

Any help would be great
Thanks in advance

 

[richary]

What version of access are you running?

 

[rzkl]

Access 2000

Access 2000

 

[richary]

that's a shame because changing printers programmatically in access 2000 is not a trivial task.

what I'm now wondering is if it is possible to run both reports for your recordset.I assume that you have some sort of SELECT query underlying both reports which use your printer field eg "WHERE printerfield=1" for the report to print to Printer1?

if that is the case you could write something like

Sub PrintTags

docmd.OpenReport "Report1PrintsToPrinter1",acViewNormal
docmd.OpenReport "Report2PrintsToPrinter2",acViewNormal

End Sub

If there are no tags to be printed to Printer2 say, the second line will have no effect - assuming that you have no headers, footers etc?

 

[rzkl]

Okay thank you I will try that out and let you know

Thanks