Open form from another database form

[jcaptchaos2]

Hello,

I have this code that I am trying to open a form on another database with, I thought I had it working but now when I run it all I get is a flash like it tried to open and then nothing.

Private Sub openvac_Click()
Dim appAccess As Access.Application
Set appAccess = CreateObject("Access.Application")
appAccess.OpenCurrentDatabase "N:\HR\Fishbowl Payroll\Missing Time.accdb"
appAccess.DoCmd.OpenForm "missingtimetbl"
Set appAccess = Nothing
End Sub

 

[boblarson]

1. You will need

appAccess.Visible = True

after the CreateObject line.


2. If you set appAccess = Nothing before disconnecting from it then it will also be a flash as it won't stay open.

Put
appAccess.UserControl = True

before the
Set appAccess = Nothing

 

[jcaptchaos2]

Bob,

Thanks it works great, the only issue I have now is getting people to stay logged out of the database so I can upgrade it.