Help! - "Module Not Found"

[Brossyg]

I have Access 2003. I have a large database and was doing some work this
morning. All of the sudden, when I click on any button that opens a query, I
get an error message "Module Not Found". The title of the message box is
"Microsoft Visual Basic".

What could I have done, or deleted? None of my buttonsd work that run
queries. The ones that run macros seem to be fine.

Help !!

Brossyg

 

[Allen Browne]

Something has been deleted, or corrupted.

1. Compact:
Tools | Database Utilities | Compact.

2. Decompile a copy of the database by entering something like this at the
command prompt while Access is not running. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

3. Make sure the Name AutoCorrect boxes are unchecked under:
Tools | Options | General

4. Compact again.

5. Open your form in design view (the one that runs the queries). Check that
the On Click property of the command button refers to a macro or code that
does exist. If necessary import the macro or module from an older copy of
the database.