Help! - "Module Not Found"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top