Set Warnings to False does not prevent message

Christine Pearc

Christine
Local time
Today, 17:23
Joined
May 13, 2004
Messages
111
The OnClick event for a cmdbutton sends a report to a SNP file. Whilst this is happening, Access displays a message that says "Now outputting... <file name and path>. I don't want this message to display, especially since there is a Cancel button on it! :eek:

How can this message be suppressed? I've tried this:

DoCmd.SetWarnings False
DoCmd.OutputTo acReport, "rpt New Employee",
acFormatSNP, "Z:\HR\Admin\NewEmp.snp", False
DoCmd.RunMacro "SendMail"
DoCmd.SetWarnings True

Cheers,
Christine
 

Users who are viewing this thread

Back
Top Bottom