Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"object or class does not support the set of events" error on form events in Access 2007 s

Status
Not open for further replies.

MacroScope

Programmer
Jul 17, 2010
286
US
I'm posting this to offer a fix for those who may encounter the above error. I have nearly 20 years experience with Access, and I never encountered the error until today. It just seemed to materialize out of nowhere but it occurred with every event procedure on one form. After troubleshooting my own work and finding nothing amiss I started searching online forums for help. There were many suggestions, including uninstalling and reinstalling Access (which I did to no avail), and after trying all that I could, I finally, out of sheer frustration and lack of other direction, decided to try the routine I use to correct Return Without GoSub error. It involves pasting the following, including quotation marks, into the run window.

"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" /decompile "Full path to your db.ACCDB"

It worked fabulously. The problem was corrected within 30 seconds.

Because I beat my brains out trying to solve this and because I came upon a simple and effective fix I wanted to share it with others. Even if you've never seen the error before, I suggest you hang on to the fix. It took me two decades, but I finally bumped into it, and if you do a Google search like I did you'll see it's not so uncommon. It'll likely happen to you someday as well.
 
You should put this in an FAQ instead of the questions, so someone can see it! Also, I would add "back up your file before you de-compile" :)

misscrf

It is never too late to become what you could have been ~ George Eliot
 
I honestly didn't know where to post it. I just wanted to let others know. It can save a ton of headaches. Everything I tried based on Google searches failed, and this was one of those desperation, shotgun things. It was a tool in my arsenal that I hadn't tried and I just figured what the hell, I'll give it a shot. I wasn't expecting success, and was very pleasantly surprised to see the problem gone for good with such a simple fix.

BTW, it hasn't come back since I posted this 12 days ago, and this is in a 20 user environment, so it seems a solid fix.

If you can point me to some other place to post this I'd be happy to.
 
That is really great. Definitely nice that you shared the tip! In each forum, there is a tab for FAQ's (Forum / Search / FAQs / Links/ MVPs)
If you post in there, it may help people to find it. Here, a great tip like that can get lost in the sea of questions. Thanks again for sharing!

misscrf

It is never too late to become what you could have been ~ George Eliot
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top