Access Database opens behind other applications

[ffrippy]

I have an access database switchboard on which I have s series of VBA coded buttons which open external (access) databases. I have a problem that when the databases open they often open behind the the switchboard, is there a way I can force the newly opened database to open in front of other applications?

Thanks for your help

[jimatqsi]

I believe normally it should open in the foreground. It may be that users are clicking again or touching some object on the screen while they wait for the new window to open - that would change which window is now considered to be the active window.

You might try following the open:

DoCmd.RunCommand acCmdAppMinimize

That will minimize the current Access app.

But if the user is quick to touch an object on a different screen you still might have your newly opened window in the background.

Jim

[ffrippy]

Thanks Jimatqsi,

that's a good idea, I did DoCmd.RunComman d acCmdAppMaximiz e on the opening database but didn't think about minimizing the Current DB... tch!