Selecting a Printer

  • Thread starter Thread starter Charles Robinson III
  • Start date Start date
C

Charles Robinson III

I am attempting to create a method in the form view where when a control
button is clicked, will provide another form view or something that allows
the user to select a printer to print to, other than the default printer.
The item being printed is a report. I am open for any suggestions or links
that may be of some help.

Thanks.

Charles Robinson III
(e-mail address removed)
 
Hi Charles,

what version of Access are you using? In Access 2002 you
can use the Applications Printer object and Printers
collection. You can search VBA help in Access for more
info. The following lists installed printers in the VBA
immediate window:
=====================
Sub showprntrs()

Dim prntr As Printer

For Each prntr In Application.Printers
Debug.Print prntr.DeviceName
Next

End Sub
===================

Any version of Access earlier than this requires using
code to talk to the Windows API with either PrtDevMode or
PrtMip (not very well documented). Someone may have some
sample code out there - any one?

hth

chas
 
Back
Top