Object or class does not support the set of events

[Mike Painter]

After opening a simple Access 2007 database that worked before, I get the
following error when trying to do any button that uses the on-click event.
"Object or class does not support the set of events."

Help gives this information:

"This error occurs when an event has failed to run because Microsoft Office
Access cannot evaluate the location of the logic for the event. For example,
if the OnOpen property of a form is set to =[Field], this error occurs
because Access expects a macro or event name to run when the event is
fired."

All the events are good and all the queries, etc. that are run exist and
work as expected.
The folder is a trusted site.

If I switch to design view and open any of the events, then switch back to
form view everything works until the next time I open the database.

Help?

 

[Arvin Meyer [MVP]]

Mike, This sounds like a corruption.

Try creating a new clean database and importing all the objects from the
problem database.

 

[Mike Painter]

I just removed the one embedded macro I had left and it seems to have fixed
the problem.
Now everything is done in code.
I'm going with that for now and try your idea if it fails again.

Mike, This sounds like a corruption.

Try creating a new clean database and importing all the objects from
the problem database.

After opening a simple Access 2007 database that worked before, I
get the following error when trying to do any button that uses the
on-click event. "Object or class does not support the set of events."

Help gives this information:

"This error occurs when an event has failed to run because Microsoft
Office Access cannot evaluate the location of the logic for the
event. For example, if the OnOpen property of a form is set to
=[Field], this error occurs because Access expects a macro or event
name to run when the event is fired."

All the events are good and all the queries, etc. that are run exist
and work as expected.
The folder is a trusted site.

If I switch to design view and open any of the events, then switch
back to form view everything works until the next time I open the
database. Help?

 

[Gina Whipp]

Mike,

As a side ote, just in case you haven't done so already... Make *sure* you
have back-ups. If it is the start of corruption you really don't want to
lose all your hard work!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I just removed the one embedded macro I had left and it seems to have fixed
the problem.
Now everything is done in code.
I'm going with that for now and try your idea if it fails again.

Mike, This sounds like a corruption.

Try creating a new clean database and importing all the objects from
the problem database.

After opening a simple Access 2007 database that worked before, I
get the following error when trying to do any button that uses the
on-click event. "Object or class does not support the set of events."

Help gives this information:

"This error occurs when an event has failed to run because Microsoft
Office Access cannot evaluate the location of the logic for the
event. For example, if the OnOpen property of a form is set to
=[Field], this error occurs because Access expects a macro or event
name to run when the event is fired."

All the events are good and all the queries, etc. that are run exist
and work as expected.
The folder is a trusted site.

If I switch to design view and open any of the events, then switch
back to form view everything works until the next time I open the
database. Help?

 

[Mike Painter]

Thank's, while this one would be easy to rebuild, I learned about backups
about 1979 when I did teh same stupid thing twice in a tired day and killed
two of my three backups.

Weird also is that I just wrote a bit about backups because of a potential
disaster in our fire department that revolves around computers and the
chiefs using his son as an "expert"

Mike,

As a side ote, just in case you haven't done so already... Make
*sure* you have back-ups. If it is the start of corruption you
really don't want to lose all your hard work!

I just removed the one embedded macro I had left and it seems to
have fixed the problem.
Now everything is done in code.
I'm going with that for now and try your idea if it fails again.

Mike, This sounds like a corruption.

Try creating a new clean database and importing all the objects from
the problem database.

After opening a simple Access 2007 database that worked before, I
get the following error when trying to do any button that uses the
on-click event. "Object or class does not support the set of
events." Help gives this information:

"This error occurs when an event has failed to run because
Microsoft Office Access cannot evaluate the location of the logic
for the event. For example, if the OnOpen property of a form is
set to =[Field], this error occurs because Access expects a macro
or event name to run when the event is fired."

All the events are good and all the queries, etc. that are run
exist and work as expected.
The folder is a trusted site.

If I switch to design view and open any of the events, then switch
back to form view everything works until the next time I open the
database. Help?

 

[Gina Whipp]

Glad to hear that... well the part about backups!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Thank's, while this one would be easy to rebuild, I learned about backups
about 1979 when I did teh same stupid thing twice in a tired day and
killed two of my three backups.

Weird also is that I just wrote a bit about backups because of a potential
disaster in our fire department that revolves around computers and the
chiefs using his son as an "expert"

Mike,

As a side ote, just in case you haven't done so already... Make
*sure* you have back-ups. If it is the start of corruption you
really don't want to lose all your hard work!

I just removed the one embedded macro I had left and it seems to
have fixed the problem.
Now everything is done in code.
I'm going with that for now and try your idea if it fails again.

Arvin Meyer [MVP] wrote:
Mike, This sounds like a corruption.

Try creating a new clean database and importing all the objects from
the problem database.

After opening a simple Access 2007 database that worked before, I
get the following error when trying to do any button that uses the
on-click event. "Object or class does not support the set of
events." Help gives this information:

"This error occurs when an event has failed to run because
Microsoft Office Access cannot evaluate the location of the logic
for the event. For example, if the OnOpen property of a form is
set to =[Field], this error occurs because Access expects a macro
or event name to run when the event is fired."

All the events are good and all the queries, etc. that are run
exist and work as expected.
The folder is a trusted site.

If I switch to design view and open any of the events, then switch
back to form view everything works until the next time I open the
database. Help?