"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
'---------------
