Command Button to launch a terminal server session

[Guest]

Hi,

I am looking for any help that anyone may offer. I need to create a button
in a form that will launch a terminal server session that will use an IP
address from a currently view record. The command for the Term server launch
is mstsc /v:[ip address from record]. Thanks in advance

 

[Arvin Meyer [MVP]]

This should work for you:

Private Sub cmdTS_Click()
Dim x
x = Shell("C:\WINDOWS\system32\mstsc.exe /v: 192.168.2.1:1433",
vbNormalFocus)
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Thank you for a pompt response. I have tryed what you wrote and it is good,
but I was wondering how make the ip address portion of the command to be
pulled from the current record in the form. The field name in the form is
called "External IP", that is also the name of column in the table called
servers. Is that possible?

Thanks in advance.

This should work for you:

Private Sub cmdTS_Click()
Dim x
x = Shell("C:\WINDOWS\system32\mstsc.exe /v: 192.168.2.1:1433",
vbNormalFocus)
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Hi,

I am looking for any help that anyone may offer. I need to create a button
in a form that will launch a terminal server session that will use an IP
address from a currently view record. The command for the Term server launch
is mstsc /v:[ip address from record]. Thanks in advance

 

[Guest]

Thanks for your help, I have played with it tonight and figured it out, I
used the forms object in access. forms!servers![External IP].value

Thank you for a pompt response. I have tryed what you wrote and it is good,
but I was wondering how make the ip address portion of the command to be
pulled from the current record in the form. The field name in the form is
called "External IP", that is also the name of column in the table called
servers. Is that possible?

Thanks in advance.

This should work for you:

Private Sub cmdTS_Click()
Dim x
x = Shell("C:\WINDOWS\system32\mstsc.exe /v: 192.168.2.1:1433",
vbNormalFocus)
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Hi,

I am looking for any help that anyone may offer. I need to create a button
in a form that will launch a terminal server session that will use an IP
address from a currently view record. The command for the Term server launch
is mstsc /v:[ip address from record]. Thanks in advance