Help with follow hyperlink method

S

swichman

Application.FollowHyperlink "I:\Projects\660110\Attachments\Dwg" &
Me.Text75, , True

I have this on the on click properties on a button on a form and I get
a message "cannot open the file specified". Can anybody suggest
anything?
Thanks,
Sean
 
D

Douglas J. Steele

Are you certain that "I:\Projects\660110\Attachments\Dwg" & Me.Text75 does,
in fact, result in a valid file name?

Try:

If Len(Dir("I:\Projects\660110\Attachments\Dwg" & Me.Text75)) > 0 Then
Application.FollowHyperlink "I:\Projects\660110\Attachments\Dwg" &
Me.Text75, , True
Else
MsgBox "I:\Projects\660110\Attachments\Dwg" & Me.Text75 & " doesn't
exist."
End If
 
Top