Multiple Databases

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Group

I have multipe databases that we use here at work. I've been asked if
there is a way to open one database from another - I have to agree it would
be nice. So what I want to do is create a switchboard kind-of-looking form
that would have command buttons that would open up a form in another
database. For instance I would like to open the WIP's (Work in Progress)
main form from while i'm still in my time card. Or if i'm in the time card
database and want to look at a memo that i created have a button that would
open the Memo database. Basically I want to open one database from within
another - like opening up multiple instances of an exe. I don't want to
merge them together because i have way too many components i.e. frm, qry,
mod etc....

Thanks Mike Sundman

(e-mail address removed)

reverse for e-mail.
 
You can always place a button on a form like:


Application.FollowHyperLink "c:\my documents\wip.mdb"

Or, to launch a word doc, you can use:

Application.FollowHyperLink "c:\my documents\myword.doc"

In fact, using the above, you can launch pictures, or PDF files....it is
just as if you clicked on the file...
 
Back
Top