Stopping the prompts

[Jarad]

Is there any way I can get the prompts from queries my macro is calling turned off. I have an append, 3 updates and a delete. It is ultimately pulling a report, I dont want the users to have to click through prompts to get the report to come up. Any ideas?

 

[KenHigg]

There is a setwarnings off in macro land and in vba that you can call that will do this -

ken

 

[Jarad]

Thanks!!

Thanks Alot!!!!!! And here I was going to code in keystrokes...