Removing Microsoft Message boxes

[Groundrush]

Greetings all

I have a Macro which runs a few queries in a certain order,
and I'm trying to find out if I can remove the message screens that you get when running them i.e

"you are about to run a make table query"
"The existing Table will be deleted"
"You are about to paste into a new table" etc

I need to use this Macro quite alot and it gets annoying when you have to click onYES about 8 times when running the macro

Looking forward to any advice

Thanks

 

[Newman]

I don't know about macros since I usualy don't use them, but if you can code it in vba, then use this:

DoCmd.SetWarnings False
...
DoCmd.SetWarnings True

Newman

 

[Groundrush]

Thanks
I shall give that a go.

 

[Graham T]

Groundrush

There is also the option to set warnings on or off in the macro actions if you are unsure about using VBA.

HTH

Graham