Hyperlink problem

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
 
C

ChoonBoy

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
 
Top