"module not found" error message

[Guest]

I am a novice programmer who is in the real estate business. I use Microsoft
Access 2000 to maintain my business information and use some code to ease my
labors.

A database I have with some code has worked fine in the past. Out of the
blue, I am experiencing some problems.

I have update event driven code associated with three controls on a form
which upon attempting to update data began giving the error message "module
not found". A Microsoft Access class object by the name of my form appears
under the project name in the Visual Basic Editor, so it would appear that
the module does exist in the project. The code associated with this module is
intact in the VBE.

What may or may not be related is another problem. Another Microsoft Access
class object wth the name "Form_Form2" also appears in the VBE. When clicking
on "Form_Form2" or when compiling the database, the following message
appears: "The form name "Form2" is mispelled or refers to a form that does
not exist". There is code associated with "Form2" in the VBE. No such form
exists to my knowledge.

My wonderfully automated form is no longer automated.

Can anyone help me solve this mystery?

Thanks,
Joe Hailey

 

[Guest]

One possibility. You have a module with the same name as a Sub or Function
in that module. If that is not the case, it could be a corruption problem.

Here are a couple of links that may help if it is corruption:
http://www.granite.ab.ca/access/decompile.htm
http://support.microsoft.com/default.aspx?scid=kb;[LN];304548

 

[Guest]

Thanks, I will check that out

One possibility. You have a module with the same name as a Sub or Function
in that module. If that is not the case, it could be a corruption problem.

Here are a couple of links that may help if it is corruption:
http://www.granite.ab.ca/access/decompile.htm
http://support.microsoft.com/default.aspx?scid=kb;[LN];304548

I am a novice programmer who is in the real estate business. I use Microsoft
Access 2000 to maintain my business information and use some code to ease my
labors.

A database I have with some code has worked fine in the past. Out of the
blue, I am experiencing some problems.

I have update event driven code associated with three controls on a form
which upon attempting to update data began giving the error message "module
not found". A Microsoft Access class object by the name of my form appears
under the project name in the Visual Basic Editor, so it would appear that
the module does exist in the project. The code associated with this module is
intact in the VBE.

What may or may not be related is another problem. Another Microsoft Access
class object wth the name "Form_Form2" also appears in the VBE. When clicking
on "Form_Form2" or when compiling the database, the following message
appears: "The form name "Form2" is mispelled or refers to a form that does
not exist". There is code associated with "Form2" in the VBE. No such form
exists to my knowledge.

My wonderfully automated form is no longer automated.

Can anyone help me solve this mystery?

Thanks,
Joe Hailey