Help with follow hyperlink method

  • Thread starter Thread starter swichman
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Still can't figure out FollowHyperlink 2
hyperlinks driving me crazy 2
question involving listbox, hyperlink, textbox 1
Using Two Fields on a Form to Select Email Addresses from a Table 7
application.followhyperlink vs ShellExecute API 3
Re : Excel Hyperlink to Open an External File 6
Sending mail to all email adresses in subform 1
Access minimizes when clicking hyperlink 2

Back
Top