Module Not Found

[Viv1]

Hi,

Every time I click on a command button or enter data that affects calculated fields I get the error 'Module Not Found', if I click Ok it opens up Microsoft Visual Basic. This started happening after I entered a record it said was violating the PK then closed it without saving the record and now non of the functionality is working can someone please help me as I don't understand the Help message:

Module not found


Modules aren't loaded from a code reference — they must be part of the project. This error has the following cause and solution:

The requested module doesn't exist in the specified project. For example, the statement MyModule.SomeVar = 5 generates this error when MyModule isn't visible in the project MyProject.
See your host application documentation for information on including the module in the project.


Thanks, Viv

 

[SiJP]

Has someone deleted any of the modules or code within?

 

[JeremyNYC]

This is posted in at least two fora. Please do not cross post, as it may lead to people wasting their time answering questions that have already been answered.

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[missinglinq]

Viv1,

Actually this error can appear in a project that does not and never has had modules. Access is sometimes confused by programmer named objects, and for some reason usually assumes that they are modules names. You should be especially careful using names that are the same or similar to Access/VB reserved words and names, and always Dim variables with their variable types. Access can get very addled at times, just like programmers!

You need to do some old fashioned debugging of your code, to see if you have any errant code. Unless, of course, you were a good little programmer do bee, and have a backup copy of your db!

Also, a situation I've run across is where some real problem crops up as you're entering data. The debugging screen comes up and you keep entering data, but entering it in the code window! Something like that should also be obvious to the naked eye.

You just can't beat regular backing up of code. It's a shame Access doesn't have a feature for this!

The Missinglinq

"It's got to be the going,
not the getting there that's good!"
-Harry Chapin