modules in a library DB reference an instance defined in main DB

[Guest]

Modules in a library database should be able to reference an instance of a
class that is defined in the main database

 

[Paul Overway]

There is a trick to making classes in library MDEs available in the main
database. See:

http://www.mvps.org/access/modules/mdl0034.htm

 

[Guest]

Yes I know that trick, but once you have instanced the class in the main
database and then need to use its return values in the library database e.g.
for a form, you can't do this can you?

 

[Paul Overway]

No. In that case, you would need to pass your instance of that class to
whatever routine requires it. But that would apply in any case, i.e., even
within the main database you couldn't instantiate an object and then use
that object within another routine, unless the object was declared globally.

I haven't tested it, but if the object is declared globally in the main DB,
it might be accessible within the library DB. Nevertheless, passing a
reference to the object would be better in practice.