Open words from access ?

[SpookiePower]

I have made a customer database and to each customer in the database,
there is a word file. When it show a customer on a form, I would like
to give the user, the choice, to open the word file by a click on a
button on the form. Is this possible ?

 

[Douglas J. Steele]

As long as you know the full path to the Word file, you can open it using
FollowHyperlink:

Application.FollowHyperlink "C:\Folder\File.doc"

Note that you can use a variable to hold the file path:

Dim strFile As String

strFile = "C:\Folder\File.doc"
Application.FollowHyperlink strFile