action query prompts

[Guest]

I need to turn the prompts off in Access 07....does anyone know where this is
found without using VB? It used to be in options, but I cant seem to find
options in 07.

 

[Al Campagna]

Wayno,
Use
DoCmd.SetWarnings False (to turn off)
DoCmd.SetWarnings True (to turn back on after the action query)
--
hth
Al Campagna
Access MVP 2007
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love, and you'll never work a day in your life."

 

[Guest]

In order to avoid using VBA, you can create a macro with the Action set to
"SetWarnings" and enter "No" for Warnings On.