Linking Word Documents to Access record?

[n48]

Is this possible?

I'm building a contact details database and one of the tables details
correspondence between our organisation and stakeholders. In an ideal
world I'd like to be able to click on a document name in one field box
and then watch magically as the document appears in word format on my
screen.

Now I've done the hyperlink thing but can only get so far as linking
that outside of a field box. Now would this work? I'm thinking possibly
as each record only has one document name so really I shouldnt need to
place this hyperlink IN a field box, instead just have it somewhere
near that field box and a tag saying: "link to document."

Grateful for any help.

 

[Arvin Meyer [MVP]]

Using a plain text field, you can use the Hyperlink property of a command
button to open the document:

Private Sub cmdHyperlink_Click()
Me.cmdHyperlink.HyperlinkAddress = Me.Text2
End Sub