Hyperlink problem

  • Thread starter Thread starter ChoonBoy
  • Start date Start date
C

ChoonBoy

Appreciate help on this

I have a form with a textbox (file_name)

Private Sub FILE_NAME_Click()
Application.FollowHyperlink Me.FILE_NAME.Value
End Sub

This can open C:\CoyFile\dbswmal\Allen_DataNotAccurate.xls

...\dbswmal\Allen_DataNotAccurate.xls

This cannot open D:\ABC\Company\Accurate.xls (CD drive)

\\Company\accurate.xls or
..\Company\accurate.xls

Actually, it cannot open files from CD or any removable drive (flash)

Is there a way to make it work. I do not want to use map drive letter.

Thanks in advance
 
Thanks for your quick response,

Do not understand your 1st part of comment, but my file extension is correct.

The unc just cannot open files from a CD-rom and Flash drive.

What is happening with my Access 2003.

Regards
 
Back
Top