Opening additional DB from switchboard - doesnt full screen

shabbaranks

Registered User.
Local time
Today, 03:34
Joined
Oct 17, 2011
Messages
300
Hi all,

Im currently creating a switchboard interface which will then access the different DB's accordingly. My current code(button) opens another instance of Access but the new instance isnt full screen. Also is there a way to cloise the switchboard DB\form upon selecting to open one of the other databases?

Code:
Private Sub DatabaseTM_BTN_Click()
Dim accapp As Access.Application
Set accapp = New Access.Application
accapp.OpenCurrentDatabase ("d:\DBHome\DatabaseTM.accdb")
accapp.Visible = True
End Sub

Thanks
 

Users who are viewing this thread

Back
Top Bottom