You CAN do this. I don't have any code to post but I'll post the help entry from A97 that should get you started.
Set a Reference to a Visual Basic Project in Another Microsoft Access Database
Each Microsoft Access database includes a Visual Basic project. The Visual Basic project is the set of all modules in the project, including both standard modules and class modules. Every Microsoft Access database, library database, or add-in contained in an .mde file includes a Visual Basic project.
The name of the database and the name of the project can differ. The name of the database is determined by the name of the .mdb (or .mda or .mde) file, while the name of the project is determined by the setting of the Project Name option on the Advanced tab of the Options dialog box, available by clicking Options on the Tools menu. When you first create a database, the database name and project name are the same by default. However, if you rename the database, the project name doesn't automatically change. Likewise, changing the project name has no effect on the database name.
You can set a reference from a Visual Basic project in one Microsoft Access database to a project in another Microsoft Access database, a library database, or an add-in contained in an .mde file. Once you've set a reference, you can run Visual Basic procedures in the referenced project. For example, the Northwind sample database includes a module named Utility Functions that contains a function called IsLoaded. You can set a reference to the project in the Northwind sample database from the project in the current database, and then call the IsLoaded function just as you would if it were defined within the current database.
To set a reference to the project in the Northwind sample database from another project:
1. Open the Module window.
2. On the Tools menu, click References, and click Browse in the References dialog box.
3. In the Files Of Type box, click Databases (*.mdb, *.mda, *.mde).
4. Locate the Northwind.mdb file. If you've installed this file, it will be in the \Program Files\Microsoft Office\Office\Samples folder by default.
5. Click OK.
You should now see "Northwind.mdb" in the list of available references in the References dialog box.
· Set a reference to the project in another Microsoft Access database when you want to call a public procedure that's defined within a standard module in that database. You can't call procedures that are defined within a class module or procedures in a standard module that are preceded with the Private keyword.
· You can set a reference to the project in a Microsoft Access database only from another Microsoft Access database.
· You can set a reference to a project only in another Microsoft Access 97 database. To set a reference to a project in a database created in a previous version of Microsoft Access, first convert that database to Microsoft Access 97.
· If you set a reference to a project or type library from Microsoft Access and then move the file that contains that project or type library to a different folder, Microsoft Access will attempt to locate the file and reestablish the reference. If the RefLibPaths key exists in the registry, Microsoft Access will first search there. If there's no matching entry, Microsoft Access will search for the file first in the current folder, then in all the folders on the drive. You can create the RefLibPaths key by using the Registry Editor in Windows, under the registry key \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\8.0\ Access. For more information about using the Registry Editor, see your Windows documentation.
Bridge Players Still Know All the Tricks