We use access to track our equipment and I'd like to add a button to launch VNC to remote to the PC.
I launch VNC this way
Private Sub Command40_Click()
Dim stAppName As String
stAppName = "c:\program files\tightvnc\tvnviewer.exe"
Call Shell(stAppName, 1)
I have a field "Id_1" that contains the part of the machine name.
Lets say the value of Id_1 is 1234
but the machine name on the network is TEST-1234
Is there a way to have the button populate the VNC field with TEST-1234 ?