DoCmd.SetWarnings False does not suppress message

C

Christine

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!

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
 
6

'69 Camaro

Hi, Christine.
How can this message be suppressed?
Click to expand...

One can't suppress this message, not even by setting Echo off to prevent
repainting the screen while the report is being exported.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
P

Pete

Try the following code which will turn off screen updates and set the mouse
pointer to an hourglass:

Add before
Application.Echo False
DoCmd.Hourglass True

and not forgetting to add
Application.Echo True
DoCmd.Hourglass False
after
 
C

Christine

Thanks to Pete for the code.

Gunny, if Pete's suggestion can't actually work, what to
do? This could be disasterous for my programme! I can see
it all now... users will click "Cancel" in that little
message box, the SNP file won't be saved, automatic email
will crash, chaos and general lawlessless will prevail. :-
) Is there another way to output an Access report that
won't generate this gremlin?

Christine
 
6

'69 Camaro

Hi, Christine.
Is there another way to output an Access report that
won't generate this gremlin?
Click to expand...

Unfortunately, no. However, one can reduce the chaos and lawlessness that
will ensue by converting that macro into VBA code as a procedure. Unlike a
macro, a VBA procedure can have an error handler that one can add a message
box such as: "You have just canceled the E-mail. This report has not been
sent to any recipients."

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
C

ChristineP

Hi Pete. Just saw your message. I tried your suggestion, but it didn't make
any difference. The message box is really driving me (and users) crazy,
especially since, while it is displayed, half the form disappears. Unless I
or someone else can find a solution, me thinks the snapshot option will have
to go.

Christine
 
Top