AppActivate in MS-Access 2000/Windows XP

[afryer]

Hi all,

I hope someone can help me with an annoying problem I am having when developing an application in access.

Basically, what I am doing as part of my application is opening a DOS telnet session using the shell command. I need then to use the SendKeys event to log into the telnet session automatically, i.e send the user name and password and then perform some maintenance on the remote box. My code is as follows:

dim l_return
l_return = shell ("telnet", 1)
AppActivate l_return
SendKeys ("my user")

The problem is occurring in the AppActivate command, bringing up an error message of 'Invalid Procedure Call or argument'. Is there some difference between Access 2000 in which AppActivate seems to work and Access 2002?

If I remove the AppActivate command the code opens 26 telnet sessions for some reason

Any help would be appreciated.

Andrew

 

[sfreeman]

Code works on my machine.

Did you try it with the full path to the telnet.exe file?

Try this...

Public Sub TelIt()
On Error Resume Next
Dim l_return
l_return = Shell("telnet", 1)
AppActivate l_return
SendKeys ("my user")

End Sub