Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 722
  • Last Modified:

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
0
WallyTee
Asked:
WallyTee
4 Solutions
 
als315Commented:
Test this sample:
DBHyperlink.accdb
0
 
Dale FyeCommented:
In the click event of a button, use:

application.followhyperlink "C:\foldername\filename.doc"
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
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.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now