Set to default printer in MDE (MS Access 97)

[PRAV]

Hi, in my case, the the user opens the mde file, the forms does not
have a full bar toolbar expect the print preview and print button (the
one with the printer icon) nor the menu bar. If i compiled on my
machine to make the mde file, it will pick up my default printer (for
example 'hp laser 123', 123 is a unique number). If somebody is using
that mde on a different floor, it will give an error saying it can't
find hp laser 123, This is because they have a different printer
number. I have been searching the net about how to set the default
printer in my MDE file and i found that printer switch code at
http://www.granite.ab.ca/access/downloadsindex.htm. I included that
printer switch code as a sub form on my home form which displays all
the other printers and the default one. Beauty. If you need to print a
continous form or report, i just click on the printer icon. In my case
it works ok, but on a different floor, its getting the same error
message - can't find printer hp laser 123. Therefore do i need to
include any code on each form that picks up the default or chosen
printer from that printer list on my home form. I'm using MS Access
97. Thank you.

 

[SA]

PRAV:

What you really need to do, which is the only thing you can do, is to set
all forms and reports to use the default printer before you comple to an MDE
file and distribute the db.

If you need code to set all reports to use the default printer, stop by our
web and look in the code and design tips area under the reports section.
(you can easily modify the code to address forms as well.)