Can I use a button on a form to open a word document?

[oldlearner]

Hi all - I have a report in word which has graphs and data from my database. Am I able to add a button onto my database form that opens the word document. Is a Macro the best way? if so what instruction do I need to use.

[June7]

Try FollowHyperlink() intrinsic function in VBA.

FollowHyperlink("folderpath\filename.doc")

Review: http://allenbrowne.com/func-GoHyperlink.html

or call Windows Shell.

Dim wsShell As Object
Set wsShell = CreateObject("WScript.Shell")
wsShell.Run Chr(34) & "folderpath\filename.doc" & Chr(34)