Opening another App from Access

[Ali Edwards]

Strange thing this. I want to open another application from Access but when it does it will only open it minimized on the Taskbar when run in Windows NT, while access retains the focus. I have mangaed to make it work on my Windows 2000 PC.

I have tried the following attached to a command button:

Dim retVAL As Double
retVAL = Shell("C:\Program Files\Gosip97\Vetting\vetting.exe", 1)

and

Dim stAppName As String
stAppName = "C:\Program Files\Gosip97\Vetting\vetting.exe"
DoCmd.RunCommand acCmdAppMinimize
Call Shell(stAppName, 1)

both of which will open the app and give the app the focus on my Win 2000 PC. On the NT machine both work but only open the app minimized on the taskbar.

Does anyone have any other ways to open another app that I could try?

Many thanks

Ali Edwards

 

[ghudson]

try...

Call Shell("C:\Program Files\Gosip97\Vetting\vetting.exe", vbMaximizedFocus)

HTH

 

[Ali Edwards]

Hmmmm.........still the same thing with that but thanks anyway. Think its going to have to be opened from the windows start bar the unlazy way!!

Cheers

Ali