Linking Word Documents to Access record?

  • Thread starter Thread starter n48
  • Start date Start date
N

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.
 
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
 
Back
Top