syoung7903
Registered User.
- Local time
- Today, 20:03
- Joined
- Jan 1, 2001
- Messages
- 18
I have one database and I want the ability to click on a button and open up another database. Can I do that?
Can I open up one database from another?
- Thread starter syoung7903
- Start date
- Local time
- Today, 14:03
- Joined
- Feb 28, 2001
- Messages
- 30,035
Yes. However,...
If it is a specific database, the code behind the button can do it all.
If it is an arbitary non-constant database, you have more to do related to browsing or arbitrary file name selection.
The further catch is that the stuff in the second database don't become available through the database window. They are available within your workspace to VBA code and stuff like that. You COULD link to the second DB to make the other stuff available, but that becomes somewhat of a problem if you are looking at non-constant DB names.
Look up the help files for workspace; database variables; OpenDatabase method; and look at the examples associated therewith. If you intended to browse for the DB name, look up the CommonCtl object or search this forum for information on "FileOpen" - particularly to posts by Pat Hartman.
If it is a specific database, the code behind the button can do it all.
If it is an arbitary non-constant database, you have more to do related to browsing or arbitrary file name selection.
The further catch is that the stuff in the second database don't become available through the database window. They are available within your workspace to VBA code and stuff like that. You COULD link to the second DB to make the other stuff available, but that becomes somewhat of a problem if you are looking at non-constant DB names.
Look up the help files for workspace; database variables; OpenDatabase method; and look at the examples associated therewith. If you intended to browse for the DB name, look up the CommonCtl object or search this forum for information on "FileOpen" - particularly to posts by Pat Hartman.
