Object or class does not support the set of events

[jez_s]

Hi,

I posted the question below last week and received no response. If I
broke some messageboard rule and that's why no one responded please
let me know so I can do it properly next time. I am still looking for
some insight on this problem although I did figure out a work around.
**************************************************

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.

 

[John W. Vinson]

Hi,

I posted the question below last week and received no response. If I
broke some messageboard rule and that's why no one responded please
let me know so I can do it properly next time. I am still looking for
some insight on this problem although I did figure out a work around.
**************************************************

Just be aware that nobody is paid to answer questions here. We're all
volunteers, donating our time for the benefit of others. Not all questions get
answered; questions that are obscure, incomplete, or on subjects that aren't
familiar to whichever volunteers happen to read your question may not get any
response at all. It's nothing personal!

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.

Learning VBA will really, really repay the effort! Macros are limited, hard to
document, and harder still to debug.

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".

Sounds like the form has become corrupted. Do you have a backup? Have you
tried Tools... Database Utilities... Compact and Repair?

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.

Care to post the actual steps of the macro that cause the problem? That's
probably why you got no answer - it's impossible to debug code that we cannot
see.

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!

Rebuild the form from scratch and reenter the macro... or post the steps of
the macro and give enough information about control names, datatypes, etc.
that someone who cannot see the database would be able to help.