J
jez_s
Hi,
I have a database I've been working on for several weeks now, not
created by me originally (Access 2003). I don't know VBA and so I am
stuck using macros etc. to get it to do what I want.
A strange thing happened today. I was making some very minor changes
to validation rules on one tab of a subform, and all of a sudden every
control on the form started giving me this error whenever data was
entered "Object or class does not support the set of events".
It is related to macros on the controls that have conditions like
[CONTROL]<>6, and then use the GoToControl action to move the focus to
a different control elsewhere on the form.
If I remove the macros completely, the errors disappear. If I remove
only the conditions and leave one GoToControl action, the errors
disappear as well. It only happens when I have the conditions
included.
There are identically set up macros with conditions and GoToControl
actions all over the other tabs of the form which are still working
fine. Also, all these macros that are now causing the error have been
working fine for weeks.
Unfortunately I don't know much about Access and I don't know anything
about VBA so the information on this error I have been able to find so
far has not been useful to me.
If anyone can give me an idea of how to fix this problem without using
VBA I would be very grateful!
Thanks,
S.J.
I have a database I've been working on for several weeks now, not
created by me originally (Access 2003). I don't know VBA and so I am
stuck using macros etc. to get it to do what I want.
A strange thing happened today. I was making some very minor changes
to validation rules on one tab of a subform, and all of a sudden every
control on the form started giving me this error whenever data was
entered "Object or class does not support the set of events".
It is related to macros on the controls that have conditions like
[CONTROL]<>6, and then use the GoToControl action to move the focus to
a different control elsewhere on the form.
If I remove the macros completely, the errors disappear. If I remove
only the conditions and leave one GoToControl action, the errors
disappear as well. It only happens when I have the conditions
included.
There are identically set up macros with conditions and GoToControl
actions all over the other tabs of the form which are still working
fine. Also, all these macros that are now causing the error have been
working fine for weeks.
Unfortunately I don't know much about Access and I don't know anything
about VBA so the information on this error I have been able to find so
far has not been useful to me.
If anyone can give me an idea of how to fix this problem without using
VBA I would be very grateful!
Thanks,
S.J.