MS Access 2010 How can I open a Word document from within Access?

I'd like to be able to hyperlink to a Word document by clicking a button on an Access 2010 form.   I can't seem to find a macro to do this, and I'm not familiar enough with VBA (yet) to do it. (I just starting to learn VBA.)  

I know I can create a hyperlink from a field within a table, but I'd like to hyperlink to the document directly from the form.

Can you help me with this?   Thanks.  WallyTee
WallyTeeAsked:
Who is Participating?
 
Dale FyeCommented:
In the click event of a button, use:

application.followhyperlink "C:\foldername\filename.doc"
0
 
als315Commented:
Test this sample:
DBHyperlink.accdb
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
See:    Hyperlinks: warnings, special characters, errors

I prefer to use the ShellExec API to avoid the issue with Hyperlinks.  Here is an example I created: Document Links
0
 
WallyTeeAuthor Commented:
Thanks to all.  I'll give your suggestions a shot and see how far I can get.   WallyTee
0
 
Jeffrey CoachmanMIS LiasonCommented:
<No Points wanted>

<I'd like to be able to hyperlink to a Word document by clicking a button on an Access 2010 form.   I can't seem to find a macro to do this, and I'm not familiar enough with VBA (yet) to do it. (I just starting to learn VBA.)  >
A Macro cannot "create" a hyperlink, nor can it be easily made to Follow one.
0
 
WallyTeeAuthor Commented:
Thanks again to all.   You can close this one out.   WallyTee
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.