Question on OutputTo Method

[Guest]

Is there anyway to get rid of the annoying popup message that happens when
you run this metnod? Thanks.

 

[Dirk Goldgar]

Is there anyway to get rid of the annoying popup message that happens
when you run this metnod? Thanks.

Which annoying popup message are you talking about? OutputTo doesn't
necessarily give a message. Please post the code you are using and the
message you're talking about.

 

[Guest]

It's of the form:

DoCmd.OutputTo acOutputReport, "xxx", rtf, "yyy"

 

[Peter R. Fletcher]

and the message is?

It's of the form:

DoCmd.OutputTo acOutputReport, "xxx", rtf, "yyy"

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher

 

[Guest]

It's of the form: "Outputing report such-and-such to file such-and-such".
Actually, it's not really a popup, but an informational one that appears and
disappears.

 

[Peter R. Fletcher]

You could try
DoCmd SetWarnings False
before the OutputTo command, but don't forget to put
DoCmd SetWarnings True
after it, or you will be wondering why all sorts of bad things are
happening and you aren't being told about them!

Access may or may not consider a transient informational message that
does not require a user response as a "Warning".

It's of the form: "Outputing report such-and-such to file such-and-such".
Actually, it's not really a popup, but an informational one that appears and
disappears.

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher

 

[Guest]

I tried Docmd.SetWarnings False/True and it didn't help. Guess I am stuck
with yet another Microsoft "feature". I wonder if these people ever actually
try to use what they create.

 

[Dirk Goldgar]

I tried Docmd.SetWarnings False/True and it didn't help. Guess I am
stuck
with yet another Microsoft "feature". I wonder if these people ever
actually
try to use what they create.

Setting Application.Echo = False doesn't have an effect either. But I
wouldn't be at all surprised if the technique described here works:

http://www.mvps.org/access/api/api0037.htm

I can't say I've tried it, though.