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 / New Users / December 2007

Tip: Looking for answers? Try searching our database.

Hyperlink

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
steve goodrich - 16 Dec 2007 23:16 GMT
Is it possible to create a command button on a form that will open a folder
on the network?
I can create a hyperlink to a file but not to a folder,
any help would be appreciated
Steve
Rick Brandt - 16 Dec 2007 23:25 GMT
> Is it possible to create a command button on a form that will open a
> folder on the network?
> I can create a hyperlink to a file but not to a folder,
> any help would be appreciated
> Steve

Application.FollowHyperlink "path to folder"

works for me.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

steve goodrich - 18 Dec 2007 05:43 GMT
if I type the path to the folder I get an error message "File not found"
A path to a file works fine.
Where am I going wrong?
I use the toolbox, click the command button with the wizard enabled.  Select
application > run application and type in the path.
If you click the browse button and navigate to a folder, you have to select
a file

Steve

> Is it possible to create a command button on a form that will open a
> folder on the network?
> I can create a hyperlink to a file but not to a folder,
> any help would be appreciated
> Steve
boblarson - 18 Dec 2007 07:24 GMT
Steve:

Have you tried it this way using the right syntax:

FollowHyperlink "file:///C:\YourFolderNameHere"
Signature

Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

> if I type the path to the folder I get an error message "File not found"
> A path to a file works fine.
[quoted text clipped - 11 lines]
> > any help would be appreciated
> > Steve
steve goodrich - 18 Dec 2007 10:35 GMT
Tried you suggestion Bob but still got the same "File not found" error
message
Steve
> Steve:
>
[quoted text clipped - 19 lines]
>> > any help would be appreciated
>> > Steve
John Spencer - 18 Dec 2007 13:38 GMT
Just a confirmation:

I just tested the following

FollowHyperlink "C:\Program Files"

and it worked for me.

Access 2003 Service Pack 1
Windows XP Pro Service Pack 2

Signature

John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

> Tried you suggestion Bob but still got the same "File not found" error
> message
[quoted text clipped - 22 lines]
>>> > any help would be appreciated
>>> > Steve
boblarson - 18 Dec 2007 15:19 GMT
It's working for me, just like Rick and John.  Can you post the exact code
you're using and which event are you putting it on?  Are you sure you put it
in the VBA code window and not in the properties dialog (see here for info on
that:
http://www.btabdevelopment.com/main/QuickTutorials/Wheretoputcodeforevents/tabid
/56/Default.aspx
)?
Signature

Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

> Tried you suggestion Bob but still got the same "File not found" error
> message
[quoted text clipped - 22 lines]
> >> > any help would be appreciated
> >> > Steve
steve goodrich - 18 Dec 2007 23:13 GMT
Success. I was using the toolbox command button wizard.
I created my button without the wizard, clicked build event and typed my
path in and it worked fine.  Thanks guys
Steve
> Tried you suggestion Bob but still got the same "File not found" error
> message
[quoted text clipped - 22 lines]
>>> > any help would be appreciated
>>> > Steve
 
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.