printing

[TODDY]

I have 2 access databases on 1 pc. One needs to print to a dot matrix printer (delivery notes on pre printed stationry) and one needs to print to a laser printer. This i can do easily by using the print comand in the file menu option.
What i need to do is have a choose destination option come up automaticaly for the end users.
This programe is to be uses in a large warehouse, so the operaters will not always be pc literate, and so has to be fool proof. It has to make them choose a printer,
Help

 

[Swamp Thing]

If you select the print settings (which printer, which paper, margins, etc) for each report when it is in design view, then Access will store these settings with the respective reports. So you can actually specify all print settings on a per-report basis even within the same database.

 

[TODDY]

I have tried this but when I press the print button it still uses the default printer. What am I doing wrong.
I have set up 2 reports and set up the printer for each. This works fine for the first print but after that they both print to the default printer.
Do I have to make a macro or what.
Regards

 

[Swamp Thing]

Sorry that didn't help. Maybe you will have to fall back on a macro solution after all. I have been looking at the VBA help on printer setup; unfortunately it is not so user friendly as other aspects of Access programming. I'll post back if I can find something useful.

 

[CT Witter]

Try looking at the resources at: http://www.mvps.org/access/reports/rpt0009.htm .You can then control which printer each report is printed on.

HTH,
CT