action query prompts

[Wayno]

I need to turn off the action query prompts in Access '07. Anyone know where
this is found without using vb?

 

[Maurice]

If you are not using VB how are you opening your query? Using a button
created with the wizard or are you just double clicking on the query in the
navigation pane. You could create a macro where you set the warnings off then
run the query and then set the warnings on again.

Goto tab "Create"
Choose Macro
Press button "Show all actions"
In the first line choose from the action field combo "SetWarnings" - Action
argument "No"

In the next line in the action field choose "OpenQuery" - Action Argument
"Yourqueryname" - replace with the name of your query

In the next line in the action field choose "Set warnings" - Action argument
"Yes"

Save the macro
Run the macro, this should run your query without the warnings..

hth

 

[Pendragon]

If you want this turned off permanently on each opening of the database, then
set the warnings condition to false in your AutoExec macro.