verify if application is already running 1

[pdtit]

Hello,

I've used the Shell command behind the onclick-property of a form to open the windows calculator as follows :

shell (c:\windows\system32\calc.exe)

and it works fine.

However, everytime I click on this button, it opens another calculator.

Does anyone know any piece of code to check if an application is already open, and if so, go back to the one already open and not starting a new one ??

Regards,

Peter

 

[AvGuy]

You might try a ShellWait function. I think this might cause Access to pause while the calculator is running and return control only when the calculator is closed. Have a look at

http://www.mvps.org/access/api/api0004.htm

and see if this looks promising.

AvGuy

 

[pdtit]

AvGuy,

WOW, that's fast !!!

You showed me the right direction.

I'm back on track now, one star's for you.

Regards,

Peter