'Module not found'

[Les Isaacs]

Hi All
I have an access 2010 accdb on my windows7 laptop that has suddenly started to behave strangely After doing any development I always create a copy of the accdb: after doing so, I am now often finding that when I go back into the main accdb, the 'switchboard' form loads as expected, but when I click on any of the buttons I am getting a message 'The expression On Click you enteredas the eevnt property setting produced the following error: Module not found'. I have checked that all the code is still there behind all the buttons. Very curiously, if I go into design mode of the form, make any kind of change, and then go back into form view, everything then works Also very curiously, if I go into the backup accdb that I made, everything works
Does anyone have any ideas?
Thanks for any help.
Les

 

[The_Doc_Man]

I could imagine a corrupted database would do this. Sometimes the corruption is subtle. There is a property on forms that is "HasModule" - and you can't set it, but if you create an event routine on that module, then you automatically set it. That is one possible issue - corruption of the switchboard form.

The fix is tedious but might work easily enough. Create a new, empty database. Open that database. Now tell it to get external stuff from an Access database. Point it to your misbehaving database and use the "Select All" buttons to import everything to your new copy. That should clear up the corruption. When you are done importing things, this will allow you to rename your old database, then rename the new one to the original name. Try that to see if it clears up your problem.

 

[Les Isaacs]

Hi DocMan
Importing all the objects into a new accdb worked
I don't suppose it's worth wondering how/why the corruption came along: frustrating
Many thanks for your fix.
Les