Overriding constraint violation message
hi Arvi,
On 21.04.2010 11:00, Arvi Laanemets wrote:
It looks like I can catch the error in OnError event for form, but how
can I override the error message - usual On Error routine doesn't work
(Err.Number=0), and I'm afraid whatever message I'm programming,
standard transaction error message gets displayed too.
While you can catch them, you still need to translate them. btw, the
Err.Number should not be 0.
The problem is, that you need error handling on all forms - the On Error
event you've mentioned - and in every VBA prodedure or macro.
I would prefer a more defensive approach. Before executing such actions
check whether these actions are allowed.
mfG
-- stefan --
|