Menu form with command buttons to open variety of databases

G

Guest

I have a number of databases that I would now like to access through one main
menu. They are each located in different folders on a network drive. How can
I create or write the code for command buttons that would allow the users to
easily open each databases which contain their own front-end main menu(s) as
well? (Or perhaps there is a different solution that I'm not familiar with?)

Thanks in advance,
 
G

Guest

I got a main MDB with several more MDB's, to access each one of then, I
created a reference from the main MDB to the other's. (open code editor, from
the menu bar select Tools > Reference, and add the other mdb's).
After adding the other MDB's, the main mdb will recognize all the functions
that are in the other MDB's, so if you want to open a form in another mdb,
you create a function on the sub mdb that call that form, and from the main
mdb you can run this function that will open that form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top