Selecting a Printer

[chas]

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