Stopping the Printing Dialog when Outputting Reports

  • Thread starter Thread starter Rich Schoenfeld
  • Start date Start date
R

Rich Schoenfeld

I have the following line of code:

DoCmd.OutputTo acOutputReport, "SalesReport", acFormatSNP, strFilePath,
False

It puts a report into the Snap Format. While it is doing this, it shows the
'Printing' Dialog box showing which page it is completing....

Is there a way to prevent this box from showing up.

I have tried the SetWarnings to off... I aso tried turning Echo to off.

No luck,

Any thoughts,

Thanks,
Rich
 
Try:

Screen.Echo False
DoCmd.OutputTo ...
Screen.Echo True

Beware that Echo Off freeze the screen and if the process
takes a long time, the user may think that Access has got
stuck.

And to be safe, you need to trap for *any* error and the
set Echo True to get the screen active again.

See Access VB Help on Echo for arguments.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top