If your function is in DB_1.mdb and you want to call it from DB_2.mdb, open any code module in DB_2. Select Tools | References from the menu. Add a reference to DB_1.mdb. You'll need to browse to DB_1 in order to add it.
See the on-line help for "library databases". Help cautions that the DB_1 should contain only code so use this method cautiously if DB_1 contains data, reports, forms, etc. I've added a reference to an MDB that contains many objects in addition to the code modules and thus far haven't encountered any problems. Terry L. Broadbent FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
The "caution" is a reminder that the REFERENCE only gives you access to the MODULES, and does not open the forms / reports / tables to the referencing user.
MichaelRed
m.red@att.net
There is never time to do it right but there is always time to do it over
Thanks Michael. Terry L. Broadbent FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.