ACC: "A Module Is Not a Valid Type" Compile Error Message
Article ID: 138018
Article Last Modified on 1/19/2007
APPLIES TO
- Microsoft Access 95 Standard Edition
- Microsoft Access 97 Standard Edition
This article was previously published under Q138018
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
When you compile a database in Microsoft Access 7.0 or 97, you may receive
the following error message:
A Module is not a valid type.
CAUSE
The module has the same name as a Microsoft Access object or a data access
object, and it contains a variable declared as the same object type as its
name. For example, if the module is named Form, you will receive the error
message if any of the module's procedures contains a form variable such as
the following:
Dim f as Form
RESOLUTION
Rename the module to a name other than a Microsoft Access object name or a
data access object name.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 7.0
and 97.
REFERENCES
For more information about naming conventions, search the Help Index for
"naming conventions," or ask the Microsoft Access 97 Office Assistant.
Keywords: kbbug kberrmsg KB138018