copy current field from form

[wlln001]

I have a form which contains IP addresses for devices in a network.I need to create a Button which will copy the current records IP address to the clipboard and then run a application which logs on to the device.The application I use is SecureCRT and I have a script which used the clipboard to automatically logon to the network device using SSH...I have setup a macro on a button to launch SecureCRT and run the script, but i need the current record in the clipboard first...I do not have much experience of VB hence why I am trying to use a macro..Hope someone can help

 

[donbettis]

You should be able to do something this like this to copy the field into the clipboard...

Me.IPAddress.SetFocus 'Set the focus to the filed holding the IP Address...
DoCmd.RunCommand acCmdCopy 'Copy the field into the clipboard...
Call Shell("C:\Program Files\PATH\TO\SecureCRT.exe", 1) 'Open SecureCRT

 

[wlln001]

that is fantastic... works a treat...

Thank you

 

[donbettis]

Glad I could help...