Hyperlink for Roger Carlson or anyone else who might help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I have used a small sample database called "SetHyperlink" from www.rogersaccesslibrary.com to be able to load a file browser and then create a hyperlink based on the file selected

My problem is that creates a hyperlink to my mapped drive (let's say "0") instead of the server path name ("app\eng\group1\". How can I overcome this issue

Daniel
 
Try this the syntax as an example on the Hyperlink
Address: -

\\ServerName\SharedDriveName\Directory\FileName

e.g.

\\ESEServer\msdosu\TestDatabases\TestDb001.Mdb.

HTH.

TC.
-----Original Message-----
Hello,

I have used a small sample database
Click to expand...
called "SetHyperlink" from www.rogersaccesslibrary.com to
be able to load a file browser and then create a hyperlink
based on the file selected.
My problem is that creates a hyperlink to my mapped drive
Click to expand...
(let's say "0") instead of the server path name
("app\eng\group1\". How can I overcome this issue?
 
Daniel P said:
Hello,

I have used a small sample database called "SetHyperlink" from
www.rogersaccesslibrary.com to be able to load a file browser and
then create a hyperlink based on the file selected.

My problem is that creates a hyperlink to my mapped drive (let's say
"0") instead of the server path name ("app\eng\group1\". How can I
overcome this issue?
Click to expand...

I'm not familiar with Roger's code, but at the link below is code for a
module that, among other things, contains a function named "fGetUNCPath"
that calls the Window API to translate from a mapped drive letter to a
UNC path.

http://www.mvps.org/access/api/api0003.htm

For your purposes, you don't need everything in that module (though you
need at least some of the declarations at the top), and you would need
to convert the function declaration from Private to Public in order to
call it from outside the module, but a quick test shows that it works
fine.
 
Daniel said:
Dirk,

I can't seem to get it to work?!

I copied to whole API code and have changed the fGetUNCPath function
to public.

then I call the function in another sub to convert the drive letter
to a UND Path.

But I can't get it to work.

Any Idea...could you send me your simplified code?

Daniel
Click to expand...

Did you specify the drive letter with the terminating colon? This works
for me:

?fGetUNCPath("K:")
\\STRIDER\STRIDER'S C
 
Back
Top