How to Supress the Update and Append Warning Boxes?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Howdy from Oklahoma again!!!

I am new to ACCESS (but getting better with everyones help!) and I have
built a form that does some data updating and appending of records but the
Notification Boxes keep popping up when the action is going to Update or
append data.

Is there anyway to turn this off? I looked everywhere in ACCESS help and on
the web before coming here so maybe it just cannot be turned off but I just
hope this is sometning else I need to learn!!!

Any assistance would be greatly appreciated!!!
And as always THANKS IN ADVANCE!!!!

Chip
 
Another method will be,

If you want to remove the messages for all queries, without using the set
warnings, then in the menu bar select
Tools > Options > Edit/Search (Tab) > Confirm Action Queries (remove the
selection)

But you have to know that it will never prompt with the message event when
you are using the queries directly
=========================
Or, to execute the query

CurrentDb.Execute "QueryName" , dbFailOnError
 
Back
Top