Is it possible to detect other programs?

[ErikZ]

Hi, I'm writing a report converter. I don't have the skills/time to have Access receive a file from the mainframe, so I'm using a Tcprint program to do it. I would like Access to detect if this program is running, is this possible?

Also, any pointers on receiveing files would be great. We use Rumba here, and I think it sends it to the Netware address my computer is on.

 

[franklin1232]

Does the Tcprint program run on your windows desktop? If so use VBA and the win32 API to find the Tcprint program.

Public Declare Function GetWindowText Lib "user32" _
Alias "GetWindowTextA" (ByVal hwnd As Long, ByVal _
lpString As String, ByVal cch As Long) As Long

Public Declare Function FindWindow& Lib "user32" Alias "FindWindowA" (ByVal _
lpClassName As String, ByVal lpWindowName As String)

There probally a better way, but this would work. It will get the title text of the app. You can search for TcPrint and if the functions returns null then the application isn't running. I thought there was a function to find the process image name, but I can find it.

 

[ErikZ]

Interesting. I'll give it a shot when my brain doesn't feel like oatmeal.

Thanks!

 

[peachmelba]

Erikz

If you are feeling lazy try this link

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

regs

peachmelba