Hi,
I have searched this forum and others but found no answer.
I have a accdb file from which i am trying to open an other accdb file using vba
Dim oAccess As Object
Set oAccess = CreateObject("Access.Application")
strdb = " 'path' "
With oAccess
.OpenCurrentDatabase strdb
.Visible = True
.UserControl = True
End With
Everything works fine except that the second db does not open maximized, but partly occupying the screen. How do i get it to open maximized (i mean not a form to maximize)? While playing with several codes realized that the randomly or without my control the first db also fails to maximize. How is it controlled?
thanks
Wysy
I have searched this forum and others but found no answer.
I have a accdb file from which i am trying to open an other accdb file using vba
Dim oAccess As Object
Set oAccess = CreateObject("Access.Application")
strdb = " 'path' "
With oAccess
.OpenCurrentDatabase strdb
.Visible = True
.UserControl = True
End With
Everything works fine except that the second db does not open maximized, but partly occupying the screen. How do i get it to open maximized (i mean not a form to maximize)? While playing with several codes realized that the randomly or without my control the first db also fails to maximize. How is it controlled?
thanks
Wysy
