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.

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JString" <JString@discussions.microsoft.com> wrote in message
news:F42767EB-255C-4DF0-B93C-1E20C7930495@microsoft.com...
>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.

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" wrote:

> 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.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "JString" <JString@discussions.microsoft.com> wrote in message
> news:F42767EB-255C-4DF0-B93C-1E20C7930495@microsoft.com...
> >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.
>
>

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JString" <JString@discussions.microsoft.com> wrote in message
news:CC62D0C1-0E85-4063-9452-3C6EBEF38584@microsoft.com...
> 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" wrote:
>
>> 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.
>>
>> --
>> Allen Browne - Microsoft MVP. Perth, Western Australia
>> Tips for Access users - http://allenbrowne.com/tips.html
>> Reply to group, rather than allenbrowne at mvps dot org.
>>
>> "JString" <JString@discussions.microsoft.com> wrote in message
>> news:F42767EB-255C-4DF0-B93C-1E20C7930495@microsoft.com...
>> >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.
>>
>>