VBA Error handling

snagrat

Registered User.
Local time
Today, 20:35
Joined
Apr 2, 2002
Messages
61
What code do I have to put in so that Access does not display the messages when deleting or ammending or adding a recond?

I know it is possible to do it in options but I want VBA to control the error handling and not access.

Cheers in advance
 
DoCmd.SetWarnings False

run your update, delete, etc query

DoCmd.SetWarnings True
 

Users who are viewing this thread

Back
Top Bottom