B
Bill
Hey gang,
I fixed the opening of our databases maximized with the help of Jim/Chris -
THANKS!
However, now I have another problem. I have created the MDBs and split them
into front ends and back ends. I then took the MDB front ends and made MDEs
out of them and used the MDE files link to the code for the buttons of the
"main" database.
If I double-click on either the MDB or the MDE, the switchboard opens in the
middle of the window. When I click on the button on my "main" database, the
window opens maximized now, but the switchboard is at the top left!
Any additional fixes or ideas? My code (below in the thread) is still what
I use for a sample.
Private Sub cmdMyButton1_Click()
' Initialize string to database path.
Const strPath = "H:\MyPath\"
strDB = strPath & "MyFile.mde"
' Create new instance of Microsoft Access.
Set appAccess = _
CreateObject("Access.Application")
' Open database in Microsoft Access window.
appAccess.OpenCurrentDatabase strDB
'Closes Main Form database'
Application.Quit
End Sub
Thanks again!
Bill
I fixed the opening of our databases maximized with the help of Jim/Chris -
THANKS!
However, now I have another problem. I have created the MDBs and split them
into front ends and back ends. I then took the MDB front ends and made MDEs
out of them and used the MDE files link to the code for the buttons of the
"main" database.
If I double-click on either the MDB or the MDE, the switchboard opens in the
middle of the window. When I click on the button on my "main" database, the
window opens maximized now, but the switchboard is at the top left!
Any additional fixes or ideas? My code (below in the thread) is still what
I use for a sample.
Private Sub cmdMyButton1_Click()
' Initialize string to database path.
Const strPath = "H:\MyPath\"
strDB = strPath & "MyFile.mde"
' Create new instance of Microsoft Access.
Set appAccess = _
CreateObject("Access.Application")
' Open database in Microsoft Access window.
appAccess.OpenCurrentDatabase strDB
'Closes Main Form database'
Application.Quit
End Sub
Thanks again!
Bill