Module Not Found?

[jenntheblond]

HELP!

When I went into one of my databases this morning, I got an error 'Module not Found.' When i hit 'OK' it opened up the VBA window and was obviously running something, because it said it was in [Break] mode. None of my modules seem to be missing and when i opened up an earlier version of the database, it appears to be the same--except the older version works without a problem (other than the fact that its missing two months of data and updates).

Any clue what is going on here or how I can figure out what happened to get it fixed? AHHHHH!

 

[Calvin]

Try repairing and compacting the project. If that doesn't do it, create a new module, copy the code out of the one that gives the cannot be found error and paste it into the new module and save it. Then delete the bad module and repair and compact the project again. You may need to try a decompile & recompile as well but try this first.

 

[keith_pyrasoft]

Is it clear which module is missing? From your description of the problem, it sounds as though it may not be the one you think it is....

 

[jenntheblond]

Ok, when I tried to open a new module and then save it (following advice of 1st replier), it told me 'You tried to cancel the previous operation' four times before the little message box stopped popping up. It doesn't save any new modules or anything.

As to the second post, I have no idea what module is missing. All i know is from the main database window (which lists the objects down the left-hand side), there are 3 modules listed on the module tab. All three of these exist in both the broken version and the old outdated version. I can't tell what I'm missing, though it is certainly possible I don't know what I'm talking about. All I know is that the database doesn't work and its starting to worry me greatly.

 

[mission2java_78]

Ok, when I tried to open a new module and then save it (following advice of 1st replier), it told me 'You tried to cancel the previous operation' four times before the little message box stopped popping up. It doesn't save any new modules or anything.

As to the second post, I have no idea what module is missing. All i know is from the main database window (which lists the objects down the left-hand side), there are 3 modules listed on the module tab. All three of these exist in both the broken version and the old outdated version. I can't tell what I'm missing, though it is certainly possible I don't know what I'm talking about. All I know is that the database doesn't work and its starting to worry me greatly.

So post the db.

 

[Jack Cowley]

Make a new, blank database. Import everything except the modules from the db that is hinky. Now make a copy of this to set aside so you do not lose any data. Now import the modules from your 2 month old backup and see if that cures your problem....

hth,
Jack

 

[jenntheblond]

Thanks Jack, that seemed to work. Thanks!

 

[Jack Cowley]

You are welcome. I am glad that it worked for you....

Jack