Suppress Query Boxes

[juliesmomma]

I have macro to run several queries (update query, append query, delete query...). When it runs, the query prompts the boxes that tells you what it is doing. Is there a way to suppress those pop up boxes that tells you it is updating rows, appending rows, deleting rows....? Any info would be very appreciated.
Thanks,
April

 

[HitechUser]

sweetpea37186,

You can disable warnings in the macro or using VB code. Pick the one that works for you.

Try this link (it has both).

http://www.tek-tips.com/viewthread.cfm?qid=975157

I hope this helps.

 

[PHV]

Take a look at SetWarnings

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[juliesmomma]

Hey THANKS a million! That worked like a charm!