Article ID: 151572
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 Q151572
SYMPTOMS
Advanced: Requires expert coding, interoperability, and multiuser skills.
When you compile a module in which a procedure is trying to call a
procedure that is defined in a class module in another database, you may
receive the following error message:
Method or Data Member not Found.
CAUSE
Class modules are private in scope to the Visual Basic project in the
database in which they are defined. Therefore, procedures in class modules
cannot be referenced in another Visual Basic project.
This article assumes that you are familiar with Visual Basic for
Applications and with creating Microsoft Access applications using the
programming tools provided with Microsoft Access. For more information
about Visual Basic for Applications, please refer to your version of the
"Building Applications with Microsoft Access" manual.
RESOLUTION
You can use one of the following two methods to work around this behavior.
Method 1
Store the procedure in a standard module rather than a class module. This
would make the procedure directly accessible from other databases but would
require that you convert your class module procedures to standard module
procedures.
Method 2
Create a function in a standard module in the database where the class
module is defined. This function would call the procedure from the class
module. Then, you would call this function from a standard module of
another database. This allows you to leave your class module procedures as
is, but would require that you write a standard procedure for each class
module procedure you want to run.
REFERENCES
For more information about creating references to other databases, search
the Help Index for "Referencing, Other Databases," or ask the Microsoft
Access 97 Office Assistant.
For more information about class modules, search the Help Index for "Class
Modules," or ask the Microsoft Access 97 Office Assistant.
Keywords: kberrmsg kbprb kbprogramming KB151572