OPENING OTHER DATABASES FROM AN ACCESS DATABASE

[Guest]

I HAVE ABOUT 20 DATABASES STORING DIFFERENT INFORMATION. I WANT TO CREATE A
SINGLE FORM IN A DATABASE WHICH WHEN I CLICK ON A BUTTON IT WILL OPEN THE
SWITCHBOARD MENU IN THE OTHER DATABASES. I HAVE TRIED THE RUN APP COMMAND IN
THE MACRO DESIGNER BUT THIS WILL ONLY LET YOU OPEN THE APPLICATION ITSELF AND
NOT A SPECIFIC FILE. IS THERE ANY SIMPLE MACRO CODE TO DO THIS JOB?

 

[Joseph Meehan]

I HAVE ABOUT 20 DATABASES STORING DIFFERENT INFORMATION. I WANT TO
CREATE A SINGLE FORM IN A DATABASE WHICH WHEN I CLICK ON A BUTTON IT
WILL OPEN THE SWITCHBOARD MENU IN THE OTHER DATABASES. I HAVE TRIED
THE RUN APP COMMAND IN THE MACRO DESIGNER BUT THIS WILL ONLY LET YOU
OPEN THE APPLICATION ITSELF AND NOT A SPECIFIC FILE. IS THERE ANY
SIMPLE MACRO CODE TO DO THIS JOB?

Please don't use ALL CAPS, it is really hard for most people to read.
It is considered SHOUTING!

I have about 20 databases storing different information. I want to
create a Single form in a database which when I click on a button it will
open the Switchboard menu in the other databases. I have tried the run app
command in



The macro designer but this will only let you open the application
itself and Not a specific file. Is there any simple macro code to do this
job?



If these are all Microsoft Access databases, you can just link to each
of the databases, as long as you have good access the them and you then can
use the linked table as if it were part of your database.



So you will then just use the switch board or whatever to open each
table.

 

[Joseph Meehan]

I HAVE ABOUT 20 DATABASES STORING DIFFERENT INFORMATION. I WANT TO
CREATE A SINGLE FORM IN A DATABASE WHICH WHEN I CLICK ON A BUTTON IT
WILL OPEN THE SWITCHBOARD MENU IN THE OTHER DATABASES. I HAVE TRIED
THE RUN APP COMMAND IN THE MACRO DESIGNER BUT THIS WILL ONLY LET YOU
OPEN THE APPLICATION ITSELF AND NOT A SPECIFIC FILE. IS THERE ANY
SIMPLE MACRO CODE TO DO THIS JOB?

Please don't use ALL CAPS, it is really hard for most people to read.
It is considered SHOUTING!

I have about 20 databases storing different information. I want to
create a Single form in a database which when I click on a button it will
open the Switchboard menu in the other databases. I have tried the run app
command in



The macro designer but this will only let you open the application
itself and Not a specific file. Is there any simple macro code to do this
job?



If these are all Microsoft Access databases, you can just link to each
of the databases, as long as you have good access the them and you then can
use the linked table as if it were part of your database.



So you will then just use the switch board or whatever to open each
table.