Detecting Running Applications

[PeterM]

I'm running Access 2003 with an Access 2000 format
database. I have a button on a form which calls an
application (such as MS Word). I need to program the
button to check and see if the application (Word) is
currently running and if it is, simply switch to it. If
it's not running I need to start it.

How can I check for applications currently running on my
desktop?

 

[Cheryl Fischer]

There is code at the Access Web that will do that for you:

API: Find out if an application is currently running
http://www.mvps.org/access/api/api0007.htm

 

[Albert D. Kallal]

I also have some sample word merge code that launches word if need be..but
runs the existing copy.

Try running my word merge code example.

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

After you run it..and try it...take a look at the code. There is about 3 or
4 places where I first check for word running..and if not launch it.

No API code is needed to do this..

My sample code also have fixes for focus problems when switching from
ms-access to word.