are there any workarounds for using a specific printer for a report in
access 2007?

something i can write in code?

i have 12 different label printers and based on which btn the user
clicks it will print a label on a specific printer.

if i can't get this fixed i may have to uninstall 2007 untill there is
a way to fix this as we need to be able to print theses labels.

Thanks

You can set the Printer object before you OpenReport.

Here's an example of how to allow the user to choose one of their printers
(even if you don't know what printers they will have.) It then remembers the
printer, and uses it again next time you open that report.
Printer Selection Utility - Users assign printers to reports
at:
http://allenbrowne.com/AppPrintMgt.html

--
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.

<scousineau (AT) oaeusa (DOT) com> wrote

On Jan 21, 9:54*am, "Allen Browne" <AllenBro... (AT) SeeSig (DOT) Invalid> wrote:

If i follow that suggestions it appears that the user will now have to
view the label prior to printing.

currently (or before i upgraded to A2007) the user would click the
button and the label would just print.

if at all possible is that still an option and if so how would i go
about that in A2007.

if not then...

I have to set it to print preview and then click print if i need to
send specific printer options correct?

Thanks

The way the utility is set up, you have to preview the report *once* to
assign the printer to it.

After that, the code assigns that printer before opening, so you don't have
to preview it each time.

--
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.

<scousineau (AT) oaeusa (DOT) com> wrote

On Jan 21, 9:54 am, "Allen Browne" <AllenBro... (AT) SeeSig (DOT) Invalid> wrote:

If i follow that suggestions it appears that the user will now have to
view the label prior to printing.

currently (or before i upgraded to A2007) the user would click the
button and the label would just print.

if at all possible is that still an option and if so how would i go
about that in A2007.

if not then...

I have to set it to print preview and then click print if i need to
send specific printer options correct?

Thanks

On Jan 21, 11:05*am, "Allen Browne" <AllenBro... (AT) SeeSig (DOT) Invalid>
wrote:

Allen, as always thank you for your help, many of us would be lost
with out it!

Shane