Printing without print dialog

[latex88]

Is there a VBA code that would allow me to bypass the print dialog, you know the pop-up window that allows you to select which printer, pages, etc.? I want to skip skip that process.

 

[boblarson]

DoCmd.OpenReport "Report Name Here", acViewNormal

will print directly to the default printer without even viewing it first.

 

[pbaldy]

DoCmd.OpenReport...

can print straight to the default printer.

 

[latex88]

DoCmd.OpenReport "Report Name Here", acViewNormal

will print directly to the default printer without even viewing it first.

I have this code in VBA and it does send to the printer automatically without preview, but I have to click print in the printer dialog. Please see attached for reference.

 

[boblarson]

It doesn't do that for me. Have you tried setting a different printer as the default for you and see what that does? It may be the way that particular printer is.

 

[latex88]

That is the only printer I have installed on this computer and it's set as a default printer. It is a receipt printer. I'm not sure if that makes a difference.

 

[latex88]

Bob,

Your code works perfectly fine. I had a different code which I copied from the VBA after I converted from a macro. It was not exactly the same. Thanks for your help with this.