How to Supress the Update and Append Warning Boxes? in Access Database Forms    |   |  Help   Search For:     In:   Office   Access Database     Access Database General Questions     Access Database New users     Access Database design     Access Database Forms     Access Database Forms Coding     Access Database Import/Export Data     Access Database Install and Configure     Access Database Macros     Access Database Programming     Access Database Queries     Access Database Reports     Access Database Security              Chip 4/9/2006 8:00 AM PST   Question   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     Was this post helpful to you?         Reply |   Top           Arvin Meyer [MVP] 4/9/2006 8:09 AM PST   Answer   DoCmd.SetWarnings False ' run your code DoCmd.SetWarnings True Always set them true, preferrably in your exit routine, so your error handler won't bypass them. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads http://www.datastrat.com http://www.mvps.org/access "Chip" <Chip@discussions.microsoft.com> wrote in message news:EE8765E6-669D-4B28-BC32-B6B136822445@microsoft.com... > 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     Was this post helpful to you?         Reply |   Top           Ofer Cohen  4/9/2006 9:37 AM PST   Answer   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 -- HTH, Good Luck BS"D "Chip" wrote: > 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     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies