Easy question

[pdbowling]

Hey all.
I can't remember how to do this simple operation.

When I run an action query it asks if I'm sure if I want to do it. How do I turn that off? I'm finished coding, I just want to use the menu options. I just forgot.
Thanks everyone.
PB

 

[Bullschmidt]

To make it so warning messages don't show up during an action query:

' Turn warnings off.
DoCmd.SetWarnings False

[Do your action query]

' Set back to normal.
DoCmd.SetWarnings True

Best regards,
J. Paul Schmidt

http://www.Bullschmidt.com

- Freelance ASP Web Developer

http://www.Bullschmidt.com/DevTip.asp

- ASP Developer Tips

 

[Carina1628]

Tools menu, click Options, Edit/Find tab.

Clear check mark in action queries box under Confirm.

Hope this helps.

 

[Carina1628]

I forgot to mention, if your query is making a table, and the table isn't later deleted, the program will still ask you if you want to delete the previous table.