2 specific printers

[flaviooooo]

Hey,

I'm not sure in which topic this fits best, so I posted it here:
Is it possible to specify 2 printers to a report?
I know it's possible to use 1 specific printer, but are 2 possible??
The way i solve this problem now is as follows: i specify a printer to the report, then copy the report and save it under a different name, and then define the other printer. But this isn't an ideal solution off course.
I'm using MS Access 97..

Thx

 

[BBaggins]

Are you trying to specify the printer at runtime, or do you want to print to 2 printers concurrently?

 

[flaviooooo]

2 printers at the same time if possible, but I'm getting so desperate the other option would also do fine ;-)

 

[markphsd]

It's possible, but it would be more easier to do two reports. If you are going to do this will a lot of reports, then look up under microsofts support site for programmatically assigning printer settings. There's a mdb on there that shows how to assign settings. I found one in Access 2000 though, i don't know if it's avalible in 97. Apparently they did a lot to make the settings more friendly in 2000, programatically and through the menu.

If this is a projected one time thing, then I suggest do the easy way. Mark P.

Bleh

 

[markphsd]

Hey, Flaviooo .. if that's your real name. I perfected it printing reports to multiple printers.
I can assign any printer through my db to any report, and save the setting--in runtime saved in a table. And I can assign multiple printers to the report. It required 2 tables and a microphone. No, wait. it required two tables, one a subtable that held all the optional printers. THe assigned procedure walks through the record set of the details table and prints off the report to all the assigned printers. Mark P.

Bleh

 

[flaviooooo]

Cool, thanks. But can you give me some more specific info on how to program this?

At this moment i had made 2 reports that have a specific printer defined, and when i print another report, it links back to one of the first reports and uses the printer it defines...

Greetz

 

[markphsd]

Hey, sorry, I didn't see that you responded.

This system has been working well for me, I figured it out a few weeks after you initialy posted this question. It was an important thing for me too.

this is what i do:

Okay, after you can gather the printers installed, and the reports you need to assign printers too, this is simply tables and looping through records. Have a main table that holds the reportname. Have a linked table that holds the printers associated with that report.

This way you can have many printers for one report. Also,
I included a default printer in the main table; its not like you are going to have many reports that need multiple printers, also if you print the report from other sections of the db its easier to reference the default printer associated with the report, rather then the associated table.

So when you want to call this report that goes to several
printers, you just write a query and loop through all the printers.

Hope that helps. If it's not adequate, i'll post code and stuff, I just didn't bring it to work today. Mark P.

Bleh