By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,233 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Open form from another database

P: n/a
Hey all!

Here's what I want to do:

I have database A.mdb and database B.mdb. They are both using SQL
linked tables, and I am utilizing a username/password login reference
the SQL tables. Each database has its specific purpose, and each has a
main menu form which signifies what each does.

What I want, is to have a button on database A's main menu form which
will launch the main menu form of database B (as if the user started in
database B). When the user is done with database B and exits, it goes
back to database A.

I know I can "reference" an external database and get to it's modules,
but how do I open a form in the other database?

Any help would be great....thanks!

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You have to use Automation. Read the Access VBA Help articles on
"GetObject Method" and "CreateObject Method" for more information.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

ex****@yahoo.com wrote:
Hey all!

Here's what I want to do:

I have database A.mdb and database B.mdb. They are both using SQL
linked tables, and I am utilizing a username/password login reference
the SQL tables. Each database has its specific purpose, and each has a
main menu form which signifies what each does.

What I want, is to have a button on database A's main menu form which
will launch the main menu form of database B (as if the user started in
database B). When the user is done with database B and exits, it goes
back to database A.

I know I can "reference" an external database and get to it's modules,
but how do I open a form in the other database?

Any help would be great....thanks!

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.