Twin
Registered User.
- Local time
- Today, 00:02
- Joined
- May 19, 2000
- Messages
- 26
Hi everybody,
ni have got the form with the selected text boxes displaying info from a table. One of those text boxes is a record id. Also, I have a button that i am trying to make do this: open word document with the name relating to the recird id displayed in the text box, ie if the textbox shows 2250 i want the button to open 2250.doc file.
so far i have this:
Private Sub cmd_start_word_Click()
On Error GoTo Err_Cmd_Start_Word_Click
Call Shell ("C:\Program Files\Microsoft Office\Office\Winword.exe""W:\Ahtsaved\2250.doc")
Exit_CmdStart_Word_Click:
Exit Sub
Err_Cmd_Start_Word_Click:
MsgBox Error$
Resume Exit_Cmd_Start_Word_Click
End Sub
This thing works no problem, but the issue is how do i replace the "2250" from the above with the code that will make it pick up the current value of the text box called aht no?
(I have tried [aht no], +[aht no]+ to no avail)
Any comments or suggestions are welcome
TIA
Chris
PS. This would have been better posted in VBA or Macro section
[This message has been edited by Twin (edited 02-15-2001).]
ni have got the form with the selected text boxes displaying info from a table. One of those text boxes is a record id. Also, I have a button that i am trying to make do this: open word document with the name relating to the recird id displayed in the text box, ie if the textbox shows 2250 i want the button to open 2250.doc file.
so far i have this:
Private Sub cmd_start_word_Click()
On Error GoTo Err_Cmd_Start_Word_Click
Call Shell ("C:\Program Files\Microsoft Office\Office\Winword.exe""W:\Ahtsaved\2250.doc")
Exit_CmdStart_Word_Click:
Exit Sub
Err_Cmd_Start_Word_Click:
MsgBox Error$
Resume Exit_Cmd_Start_Word_Click
End Sub
This thing works no problem, but the issue is how do i replace the "2250" from the above with the code that will make it pick up the current value of the text box called aht no?
(I have tried [aht no], +[aht no]+ to no avail)
Any comments or suggestions are welcome
TIA
Chris
PS. This would have been better posted in VBA or Macro section
[This message has been edited by Twin (edited 02-15-2001).]
