Turning off update query prompts

[sdfuk]

Hi

I have put some queries into a macro which I would like to run before my menu screen appears. However, when I run the macro the following message prompts appear: e.g.

"You are about to run an update query that will modify data in your table"

"You are about to update 16 rows"

"Microsoft Access can't update all records in the update query"

Basically, before the menu screen appears I have to click yes/no to all these messages.

I would like to know if there is any way of disabling / turning off these messages i.e. can you add any type of ignore error in the query itself if a record can not be updated etc. I don't want the end user to know that these queries have quietly ran in the background!!!

Thanks for any help in advance.
S.

 

[sdfuk]

OK, Ignore the question as I have just found the Setwarning option in the Macro page.

Cheers.....next problem here I come!

 

[o1110010]

I would like to know if there is any way of disabling / turning off these messages i.e.

In the macro, add a row before you run any of the queries. Set the command to "SetWarnings" with value "No". At the end of the macro, add the command again "SetWarnings" with a value "Yes" to turn back to default.

 

[o1110010]

OK, Ignore the question as I have just found the Setwarning option in the Macro page.

Oops! We must have been writing the message at the same time.