Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / August 2004

Tip: Looking for answers? Try searching our database.

hyperlink to folder

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
nd - 11 Aug 2004 22:43 GMT
Rather than having a link to a specific document, my users
want to specifiy the path to a folder but when the link is
opened, the folders "pane" is expanded. Is there a way to
set the pane to not expand when the hyperlink is clicked?
or is there some other way to link to the folder?
John Nurick - 14 Aug 2004 14:36 GMT
I don't know a way of altering how Windows responds to a hyperlink that
points to a folder rather than a file.

For alternatives, it depends what you're actually trying to deliver to
the users. For instance, you could use the code at
http://www.mvps.org/access/api/api0001.htm to open the standard File
Open dialog at the folder in question.

>Rather than having a link to a specific document, my users
>want to specifiy the path to a folder but when the link is
>opened, the folders "pane" is expanded. Is there a way to
>set the pane to not expand when the hyperlink is clicked?
>or is there some other way to link to the folder?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
nd - 16 Aug 2004 18:11 GMT
Basically, there are several .docs,.pdf, etc associated
with a record but the users don't want to insert the
hyperlink to each file, rather a link to the folder. The
one minor(?) issue is that when the link is clicked the
left hand folder pane is expanded showing the path to the
folder which they would rather not be displayed.

>-----Original Message-----
>I don't know a way of altering how Windows responds to a hyperlink that
[quoted text clipped - 16 lines]
>Please respond in the newgroup and not by email.
>.
John Nurick - 16 Aug 2004 19:22 GMT
As I said, I don't think you can control how Windows responds to a
hyperlink being clicked (Access just passes the URL to Windows). But you
could try using a text field instead of a hyperlink field, and using
something like this in the Click or DoubleClick event procedure of the
control that displays the field:

 Shell "EXPLORER.EXE """ & Me.ActiveControl.Value & """"

That should fire up Windows Explorer in the correct folder.

>Basically, there are several .docs,.pdf, etc associated
>with a record but the users don't want to insert the
[quoted text clipped - 30 lines]
>>Please respond in the newgroup and not by email.
>>.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.