Prev: Enter Parmeter Dialog Box
Next: Disabling and Re-enabling Keys
From: Aaron on 22 Mar 2010 13:25
Hello all,

I am needing some help with a piece of code I have. The code prints a
report on a printer that is not the default printer set on the PC. The issue
I have is the database window is hidden and when they click the button to run
this code is appears. How do I get it to not appear?


Set Application.Printer = Application.Printers("DOWNSTAIRS BIZ HUB")
DoCmd.SelectObject acReport, "rptEntry", True
DoCmd.PrintOut
Set Application.Printer = Nothing

Thanks in Advance,
Aaron
From: Maurice on 22 Mar 2010 15:14
Try this:

Set Application.Printer = Application.Printers("DOWNSTAIRS BIZ HUB")
DoCmd.printreport "rptEntry"
Set Application.Printer = Nothing

--
Maurice Ausum


"Aaron" wrote:

> Hello all,
>
> I am needing some help with a piece of code I have. The code prints a
> report on a printer that is not the default printer set on the PC. The issue
> I have is the database window is hidden and when they click the button to run
> this code is appears. How do I get it to not appear?
>
>
> Set Application.Printer = Application.Printers("DOWNSTAIRS BIZ HUB")
> DoCmd.SelectObject acReport, "rptEntry", True
> DoCmd.PrintOut
> Set Application.Printer = Nothing
>
> Thanks in Advance,
> Aaron
 | 
Pages: 1
Prev: Enter Parmeter Dialog Box
Next: Disabling and Re-enabling Keys