Hyperlink problem ChoonBoy 11/19/2008 8:50:10 AM 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

Re: Hyperlink problem Stefan Hoffmann <ste5an[ at ]ste5an.de> 11/19/2008 9:32:58 AM hi, ChoonBoy wrote: [Quoted Text] > Is there a way to make it work. I do not want to use map drive letter. Use ShellExecute: http://mvps.org/access/api/api0018.htm This will work, until policies are prohibiting what you are trying to do, and as long as these file (extensions) are correctly registered. mfG --> stefan <--

Re: Hyperlink problem ChoonBoy 11/19/2008 9:51:02 AM 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 "Stefan Hoffmann" wrote: [Quoted Text] > hi, > > ChoonBoy wrote: > > Is there a way to make it work. I do not want to use map drive letter. > Use ShellExecute: > > http://mvps.org/access/api/api0018.htm > > This will work, until policies are prohibiting what you are trying to > do, and as long as these file (extensions) are correctly registered. > > > mfG > --> stefan <-- >