Hyperlink field

I hope this is the right Access sub-group for this post -
apologies if not!

I'm setting up a catalogue of our team's files. This is in
Access, but the problem I am coming across also seems to
apply to hyperlinks in Excel or Word

One of the fields I have included is the filepath
excluding filename - i.e. the containing folder for the
file.
I have made this a hyperlink field so that it can be
clicked on to take the user to that folder in Windows
Explorer.

This works OK, but although the address is set to
the 'relative path' - i.e. "drive letter\folder\folder"
when the link is clicked on it opens Explorer at
the 'absolute path' - i.e. "server\share\folder".

I know its probably better practice to use the UNC instead
of a drive letter, but I feel this is more likely to be
confusing - if people are used to thinking of the folder
as "H:\Sales\...", it would be better if I could make
Explorer open up here and show the folder under "My
Computer" instead of "My Network Places".
Everybody who would use the database would have the same
share mapped to H:\ anyway, so this would still work for
the whole team.

If anyone knows what I need to do, to please could you let
me know?

Thanks for your help

"Adam" wrote in news:0b1701c4ac72
:


If anyone knows what I need to do, to please could you let
me know?



TBH, I think it would be simpler to junk all the hyperlink stuff, and just
use the Control_DblClick event to call the Shell method with Windows
Explorer. Then you could do whatever your users think is right, rather than
whatever the Access team thought was right when they were putting it
together.

HTH


Tim F

"Adam" wrote in news:0b1701c4ac72
:


If anyone knows what I need to do, to please could you let
me know?



TBH, I think it would be simpler to junk all the hyperlink stuff, and just
use the Control_DblClick event to call the Shell method with Windows
Explorer. Then you could do whatever your users think is right, rather than
whatever the Access team thought was right when they were putting it
together.

HTH


Tim F

"Adam" wrote in news:0b1701c4ac72
:


If anyone knows what I need to do, to please could you let
me know?



TBH, I think it would be simpler to junk all the hyperlink stuff, and just
use the Control_DblClick event to call the Shell method with Windows
Explorer. Then you could do whatever your users think is right, rather than
whatever the Access team thought was right when they were putting it
together.

HTH


Tim F

TBH, I think it would be simpler to junk all the
hyperlink stuff, and just
use the Control_DblClick event to call the Shell method
with Windows
Explorer.

Thanks for the suggestion - this seemed to work (Path is
the name of the text box on form that this event belongs
to):

Private Sub Path_DblClick(Cancel As Integer)

Dim strFilePath As String
Dim strExplorer As String

strFilePath = Path
strExplorer = "C:\WINNT\explorer.exe " & strFilePath

Shell strExplorer, vbNormalFocus

End Sub

Only problem is that this opens Explorer without the
folders - i.e. "My Computer" view - if anybody knows what
I would need to do to make folder open in 2-pane view by
default, this would be much appreciated?

Many thanks again

TBH, I think it would be simpler to junk all the
hyperlink stuff, and just
use the Control_DblClick event to call the Shell method
with Windows
Explorer.

Thanks for the suggestion - this seemed to work (Path is
the name of the text box on form that this event belongs
to):

Private Sub Path_DblClick(Cancel As Integer)

Dim strFilePath As String
Dim strExplorer As String

strFilePath = Path
strExplorer = "C:\WINNT\explorer.exe " & strFilePath

Shell strExplorer, vbNormalFocus

End Sub

Only problem is that this opens Explorer without the
folders - i.e. "My Computer" view - if anybody knows what
I would need to do to make folder open in 2-pane view by
default, this would be much appreciated?

Many thanks again

TBH, I think it would be simpler to junk all the
hyperlink stuff, and just
use the Control_DblClick event to call the Shell method
with Windows
Explorer.

Thanks for the suggestion - this seemed to work (Path is
the name of the text box on form that this event belongs
to):

Private Sub Path_DblClick(Cancel As Integer)

Dim strFilePath As String
Dim strExplorer As String

strFilePath = Path
strExplorer = "C:\WINNT\explorer.exe " & strFilePath

Shell strExplorer, vbNormalFocus

End Sub

Only problem is that this opens Explorer without the
folders - i.e. "My Computer" view - if anybody knows what
I would need to do to make folder open in 2-pane view by
default, this would be much appreciated?

Many thanks again

A colleague suggested just adding in the /e switch after
(strExplorer = "C:\WINNT\explorer.exe) - this worked OK

Thanks again for your help

Adam

A colleague suggested just adding in the /e switch after
(strExplorer = "C:\WINNT\explorer.exe) - this worked OK

Thanks again for your help

Adam

A colleague suggested just adding in the /e switch after
(strExplorer = "C:\WINNT\explorer.exe) - this worked OK

Thanks again for your help

Adam