By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,165 Members | 894 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,165 IT Pros & Developers. It's quick & easy.

Can I add a Word doc to my Access 2003 database form

P: 2
Hi there

New to all this and have no programming experience. Basically I am a volunteer and currently offering my I.T skills of Access to design a database to record client details. All clients produce a job history CV which is produced in a Word document.

I have created a form interface for use which also holds subforms. Is it posible to create some kind of link using a button on the form (lets call it CV)to locate on the server an individual CV.

Each CV is saved as the clients name in word, so the link would need to find the doc based on the client name. The idea being that once the link is clicked whilst on an individuals client record the link associates the db records of client name to the server where the words doc CV's are saved, then locates the client CV.

Is it possible?

Jan 10 '12 #1
Share this Question
Share on Google+
2 Replies

P: 2
Hi there I have found out that I can insert a Hyperlink field in my table. Then insert the Hyperlink to the Document. But in Access 2003 this option in data type is not available so I tried adding text, buttons etc and the hyperlink is greyed out when I right click to add it. I also tried adding links to my form, it allows me only to add the actual file and not a link, as I understand adding each file would add unnecessary data to the form.
Jan 10 '12 #2

Expert Mod 15k+
P: 31,494
You could add the address of the DOC or DOCX file to your table and this could be displayed on the form. You could then trigger code to open the document when selected (in Word as an automated application rather than within Access itself).
Jan 10 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.