printer object

[JString]

I don't know if this is possible, but I need to get the name of the printer
that a user sends a report to. I have tried using
Application.printer.devicename in the Page event of a report to do this, but
it will only return the name of the default printer, not the printer that was
selected after using File -> Print.

Does anyone know of a way to do this?

Thanks in advance.

 

[Allen Browne]

If you open a report in design view, and throgh the Page Setup dialog you
assign it to a particular printer, Access will always send it to that
printer. You will not be able to redirect it to another printer merely by
setting the default printer (in Windows) or by setting the application
printer (in Access.)

Is it really necessary to design the report for a particular printer?
Sometimes it is (e.g. for a Dymo label printer or something with really
weird page size), but if you do that, the user will have to redirect it by
previewing and redirecting through the setup dialog again.

 

[JString]

Thanks'

My boss wants to restrict access to certain printers for certain users in
Access. I figured I might be able to compare the printer name with a list of
approved devices for different work groups and if the test fails, return an
error that breaks the print process.

 

[Allen Browne]

If it's any use, this utility illustrates how to examine the user's printers
and assign them to a report (to remember for later):
http://allenbrowne.com/AppPrintMgt.html

Something in that code may give you some clues about how to do what you
want. Presumably, instead of remembering the user's printer as a custom
report property, you want to create a table of valid printers, and offer the
user only those from that table that are actually installed on their
machine.