Change Printer thru Code

  • Thread starter Thread starter Mark Schirle
  • Start date Start date
M

Mark Schirle

Hi,
I'm using Access97 with a frontend/backend database. I want to be able
to print one report on a different printer than all the rest of the
reports. I don't want users to have to do anything except push my print
button for this to happen. Can this be done in code? This would be a
network printer that I'm switching to. I would add the printer to the
computers list of printers it just would not be the default printer.
TIA
 
Mark:

With Access 97 the way to do this is to have the report set to use the
default printer and then to change the default printer in code. You can
find the code to do this in the MS Knowledgebase or MSDN or by doing a
google search. You can also check out our "On the Fly Printing" code and
classes, which do all the work for you and are also designed such that as
you upgrade your db from A97 to Access Xp or 2003, that all your code still
works. You'll find it on our web.

HTH
 
Back
Top