Hyperlink to network address

[Guest]

I have a form that allows the user to create a link to a word doc.
It also has a browse button to allow them to go find word doc if need be.

Problem, These files are on a network drive which every one has mapped
differently so my mapping to the doc may be
Z:\2006\Property\92227.doc
but someone else may be
W:\2006\Property\92227.doc
BUT...
The network address is the same
\\NetDrive\2006\Property\92227.doc

Is there a way that when the ok button on the form is hit and this link is
created that it will always use the network address?
Even when The network address is put in the text box that is used to create
the link it will still, not always, uses the mapped drive address so when the
form is brought back up it shows the mapped drive instead of the network
drive and the links do not always work.

I hope that makes sense.

Any help?

Thank You

 

[Tim Williams]

There is an API call which will get the UNC path from a mapped drive letter.

Google for "VBA UNC API"

Tim