module not found

[M.Sellers]

I have a db in Access 2003 that has a form_form2 Access Class Object
listed under my current project when I open the Visual Basic window. I
do not have an actual form2 in my database. So when I used a button on
any form in the db, I'm getting a "module not found" error. I
discovered that there was code on that form_form2 object. I thought if
I deleted that code it would stop trying to use it. Nope. I created a
dummy blank form2 and now my db can run without crashing on a "module
not found" error.

So it looks like I was creating a form and using some code on a button
that didn't work right. I thought I abandoned the form without saving
it, but apparently something got stuck and is really causing problems.

I can go to a backup but I did lots of updating before I actually
discovered this bug. What's my best course of action at this point?

Thanks, Mary

 

[Marshall Barton]

I have a db in Access 2003 that has a form_form2 Access Class Object
listed under my current project when I open the Visual Basic window. I
do not have an actual form2 in my database. So when I used a button on
any form in the db, I'm getting a "module not found" error. I
discovered that there was code on that form_form2 object. I thought if
I deleted that code it would stop trying to use it. Nope. I created a
dummy blank form2 and now my db can run without crashing on a "module
not found" error.

So it looks like I was creating a form and using some code on a button
that didn't work right. I thought I abandoned the form without saving
it, but apparently something got stuck and is really causing problems.

I can go to a backup but I did lots of updating before I actually
discovered this bug. What's my best course of action at this point?

Sounds like some kind of corruption. The first thing to do
make a backup copy in case it gets worse.

The next thing I would try is runnng Compact/Repair on the
Tools - Database Utilities menu.

If that doesn't clear it up, then create a new empty
database and set your references and other things such as
setting Name Auto Correct off. Then use File Import to
import everything (except Form2 if it's listed) into the new
database. This almost always cleans things up.

 

[M.Sellers]

Thanks for the help. I tried all the compacts, repairs, decompiles,
etc. with no luck. I finally did the import into an empty database and
that appears to have finally gotten the bug out. This database was
built in Access 97 and converted about 8 months ago. This process of
importing everything into an empty db seems to have made everything
faster once I got that Auto Name Correct turned off. THANK YOU for
alerting me to that. I NEVER would have found it and it brought
everything to a crashing halt when it was on. Thanks for being there
and helping!