Opening Access Database and Form

[guitarzycki]

I am trying to open a database from another one and go to a specific form. When I try using the method below, the new database does not get focus and the switchboard stays on top.



Dim appAccess As Access.Application

Set appAccess = CreateObject("Access.Application")
appAccess.OpenCurrentDatabase "\\wi101wsf\Shares\Departmental\Production\Machini ng\PRODUCTION\_PROCESS_DATABASE_FILES\Mach_Tools.a ccdb"
appAccess.UserControl = True
Set appAccess = Nothing

Using the shell and .bat file method (Shell "\\wi101wsf\Shares\Departmental\Production\Machini ng\PRODUCTION\_PROCESS_DATABASE_FILES\Mach_Tools.b at") the new database gets focus as desired, but I can't open the form I need

[John_G]

When you run the code, it may open the database and display a form - but your code won't necessarily stop running, so your Set appAccess = Nothing line just closes it again. Try taking that line out of that procedure to see if the database stays open.

[guitarzycki]

Thanks for the reply. Removing that line didn't seem to help. The target database is opening correctly, but it is not receiving the focus as it should. I have to go to the access on the task bar and switch to the other one.

When you run the code, it may open the database and display a form - but your code won't necessarily stop running, so your Set appAccess = Nothing line just closes it again. Try taking that line out of that procedure to see if the database stays open.

[guitarzycki]

It could be that I am going about this all wrong, but how would you open a separate database from within another and open a form in that database having it get focus?

[aytee111]

There was another thread on this exact question recently and from what I remember it is not possible unless you go via the operating system.