Does anyone know how to print a report to a specific printer, and even using
a specific tray. Using VB or even a macro.

Jeff

Just to elaborate. In this case I don't want to specify a printer for the
report in design mode. It should use the default printer, unless it is
printed to a specific printer using VB or a macro

Jeff

"Jeff" <jeff.pritchard@asken.com.au> wrote in message
news:RyxBc.131$ze3.6641@news.optus.net.au...[color=blue]
> Does anyone know how to print a report to a specific printer, and even[/color]
using[color=blue]
> a specific tray. Using VB or even a macro.
>
> Jeff
>
>[/color]

"Jeff" <jeff.pritchard@asken.com.au> wrote in message news:<vBxBc.132$ze3.6648@news.optus.net.au>...[color=blue]
> Just to elaborate. In this case I don't want to specify a printer for the
> report in design mode. It should use the default printer, unless it is
> printed to a specific printer using VB or a macro[/color]
[color=blue]
> "Jeff" <jeff.pritchard@asken.com.au> wrote in message
> news:RyxBc.131$ze3.6641@news.optus.net.au...[color=green]
> > Does anyone know how to print a report to a specific printer, and even[/color]
> using[color=green]
> > a specific tray. Using VB or even a macro.[/color][/color]

What version of Access? Newer version (A2002?) have a collection of
printers - Application.Printers I believe. Older versions can use the
code located at:

http://www.mvps.org/access/reports/rpt0009.htm

For printer tray selection check out this KB article:
http://support.microsoft.com/?kbid=200546

'---------------
' John Mishefske
'---------------