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

 

[Mike Schlosser]

Querys can call user functions.
Open the query in design view and see which function is being called.
I would guess you deleted a module containing the code.
Not sure if Access 2003 allows modules to be linked to, like tables.
If so, the link would be be in the MDB, but the link would lead to nothing.

 

[KT]

That happens to me too!! I am sure I have not deleted any modules
because I don't even touch them..It actually has happened couple times
already. No matter which button i clicked on (that worked perfectly
fine couple minutes ago), it said 'module not found'. When it opened
the VB window, it just froze and could not pull up any code that form
at all.

I fixed it by exporting all the tables, queries..etc and starting a
database, but I would have to build all the buttons (that are supposed
to tie to modules) all over. Because whenever I tried to build a new
button on the existing database, it would say "Subscript out of range"
and would not let me finish.

This is the 4th time this is happening now....It is so
frustrating..Any help will be appreciated!

Kanley