Disabling Confirmation Messages

D

Dave Ward

My users are logging onto Access secured applications and
are presented with confirmation messages for
Deletes/Updates etc.

I can easily change the flags to OFF in the Tools/Edit
menu, however this has to be done for each user accessing
the PC as the setting seems to be user based not
application or PC based.

Is there a way of altering the settings for these flags to
NO within an application using code?
 
J

John Spencer (MVP)

If you are calling the queries from code you can surround the calls with

DoCmd.SetWarnings False
'Execute your query
DoCmd.SetWarnings True

That should turn off the warning message, then execute the query, then turn on
the warnings. You can also use the execute function to run your queries.

CurrentDB().Execute strSQL, dbFailOnError
 
Top