Suppress all warnings except key violation warnings

sometimes24

Registered User.
Local time
Today, 00:35
Joined
Feb 26, 2014
Messages
10
Hello everyone,

So, I'm new to access and I've gone a long way and I have one more step before I'm done. I want to suppress the warnings that says things like about to run an append query, about to append two rows, about to delete...

BUT I want the key violation warning to show. I'm using a macro and at the beginning I set warnings to off. I know that my warning number is 10510. It occurs while an append query is running so I think I'm supposed to edit that somewhere in the Query settings - not really sure

Any ideas?
 

Users who are viewing this thread

Back
Top Bottom