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

[kittycatt]

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?

Thanks

[kittycatt]

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.

[NeoPa]

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).