How to !!!! start different Db's from a switchboard

[Guest]

I use 10 to 15 different Db's and want to creat a switchboard or main page to
launch the db's from ??? Can this be done ??

 

[Guest]

you can use the application.followhyperlink to open which ever file you wish
including databases.

Set up your switchboard to call a function that passes along the path &
filename of the database you wish to open to the application.followhyperlink
statement.

Daniel

 

[Guest]

Hi Danie

The basic call shell on the OnClick of a button would look something like this

Private Sub ommand4_Click()
Call Shell("""C:\Documents and Settings\My Documents\DataBase1.mdb""", 1)
End Sub

Or you could create an unbound combo - or bind it so you can store the DB
table names and paths in a table. Then on the AfterUpdate event you could
use something like this

Private Sub ComboName_AfterUpdate()
If Me.ComboName = Database1 Then
Call Shell("""C:\Documents and Settings\My Documents\DataBase1.mdb""", 1)
End If
If Me.ComboName = Database2 Then
Call Shell("""C:\Documents and Settings\My Documents\DataBase2.mdb""", 1)
End If
If Me.ComboName = Database3 Then
Call Shell("""C:\Documents and Settings\My Documents\DataBase3.mdb""", 1)
End If
End Sub

Or you could use an option group - if case 1 then open DB1 if case 2 open
DB2, etc.

There are quite a few methods it just depends on what you feel is best for
your app.


Don't forget you can also use call shell to run a macro when you open a
specific DB (to open a form or whatever).

Hope this helps