Help .. Required

[bzeebee]

Could you please tell me how i can check if file user entered on the form is not found in the directory "\\ABCserver\resume\" ?


If IsNull([TextBoxLink]) = True Then
MsgBox "No resume", vbOKOnly, ""
Else
Application.FollowHyperlink "\\ABCserver\resume\" & [TextBoxLINK]
End If

 

[trucktime]

If not found

Try ad an Error Handler, it will give a message in case the document is not found.

Private Sub yoursub_Click()
On Error GoTo ErrorHandler

If IsNull([TextBoxLink]) = True Then
MsgBox "No resume", vbOKOnly, ""
Else
Application.FollowHyperlink "\\ABCserver\resume\" & [TextBoxLINK]
End If

ExitSub:
Exit Sub

ErrorHandler:
MsgBox "Document not available", vbOKOnly, ""
Resume ExitSub
End Sub

Good Luck
Trucktime