Switch to Another Application that is running in the background.

[rcrobman]

This was not as simple as I had hoped!
Does anyone know how to bring an application to the foreground from within Access?
For example - Access is the foreground application (full screen) and Excel is running in the background (or minimized). What is desired is a button on a form that will make the background application (Excel in this case) come to the foreground. The application in the background has built in functions to activate any other application that is running in the background.
Sure hope I haven't missed it but a search of Access help, forums etc has not shown me the answer so far!
Any help is appreciated!


Thanks
RCRobman

[NoellaG]

Hi,

you can create an Excel application object and use it to bring the desired spreadsheet to the foreground.

gr
NG

[rpeare]

DoCmd.RunCommand acCmdAppMinimize

this should minimize the access window and take you to whatever the next underlying application is.

[rcrobman]

DoCmd.RunCommand acCmdAppMinimize

this should minimize the access window and take you to whatever the next underlying application is.

Ahhhhh always more than one way to solve a problem - didn't think of that - get rid of Access!
Thanks for the help!
RCRobman

[rcrobman]

Hi,

you can create an Excel application object and use it to bring the desired spreadsheet to the foreground.

gr
NG

That too might work.
I think getting rid of Access is a better idea - probably simpler too!
Thanks for the suggestion.
RCRobman