Swithboards...

[viperstingray]

Hi,

I am trying to write a SIMPLE database to load on my co-workers desktop that would allow him to open whatever application they desire. I know I can use a switchboard for this but I don't know how to write the macro to handle such a command.

Example:
The user would open the 'switchboard database' which would list 5 other access databases that are already built. They would click on the button corresponding to the database that they want and it would open in.

Switchboard database > Select desired application to run > CLICK > Open desired application.

Any help is GREATLY appreciated.

 

[DJkarl]

You want a SIMPLE database but what you want to do is beyond what a SIMPLE macro can do. You need a bit of VB code, you can either use an object oriented approach like

Dim msApp as Access.Application

Set msApp = GetObject("Path to your database")

Or use the Shell command to open the other database.

Search the forum for examples of either and I'm sure you'll find plenty.

 

[viperstingray]

The above does not seem to work. I'll try the shell command though (I have to learn it first!)

Any other ideas?!?!?!

 

[Zigzag]

Do a search for

APPLICATION.FollowHyperlink

I think it might be what you are looking for.

Garry