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?
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?