Open a specific Word doc from an Access query result field?

[dougmeece]

Good Morning Everyone,

I had a idea that I woulld like to pose to the forum. I have no idea if this is possbile but from what I could find searching it does not appear to be.

I created a datebase of my writings with two forms, one for creating records and one for searching records. If I wanted to open Word to read one of my writings from the results of a query by double-clicking on the title, is that possible?

In other words I want to run a search from my search form, have the results display in the subform on my main search form, double-click on of the titles in the results and have MS Word open the writing in a Word document.

Thanks,
Doug

[hjozinovic]

hi Doug!

1. You could make an attachment field in your writings database.
When entering a new Writing you then attach a word file to that record.
Later on you can access to that word document by opening the attachment.

looks like an e-mail attachment :-)

To make an attachment field, go to table design, add a new field, and from Field type select 'attachment' (only Access 2007)

2. The other way is to select 'Hyperlink' from Field type. Than you can put a link inside pointing to your Word document.

best,
H.