Two Databases - One Switchboard (1 Viewer)

[uksoldier]

I have two medical databases. I want to see them on one Switchboard.

Anyone help ? I read somewhere about making each DBase a hyper link, but the Switchboard Manager hasnt got that option...

Help pleeeeese

Thanx

 

[DJN]

I havn't used the hyperlink method, so not sure how it works. I use the following code behind a command button.

Private Sub cmdOpenDB_Click()
On Error GoTo Err_cmdOpenDB_Click

Dim strAppName As String

strAppName = "C:\Program Files\Microsoft Office\Office\msaccess.exe " & "PathAndDBName"
Call Shell(stAppName, 1)
DoCmd.Quit
Exit_cmdOpenDB_Click:
Exit Sub

Err_cmdOpenDB_Click:
MsgBox Err.Description
Resume Exit_cmdOpenDB_Click

End Sub

David

 

[Mile-O]

On the hyperlink address of a command button you just put the path of the database.