Opening a word document through Access!

[rsmith64]

I would like to have Access open a Word document with the click of a form button, and insert the data onto the page using a query that I have created.

How do I go about doing this? I can only get Access to open Word itself right now...

 

[hennep]

add a reference to the "Microsoft Word 8.0 Object Library"

and there you go:

Dim objWord As Word.Application
Dim objDoc As Word.Document
Dim objRange As Word.Range
Set objWord = New Word.Application
'Set objWord = GetObject(, "Word.Application&quot ' to use an existing word session
Set objDoc = objWord.Documents.Add("""YourWordTemplate.dot""&quot ' open a new document using a template
Set objRange = objDoc.Goto(What:=wdGoToBookmark, Name:="TheNameOfTheBookMark&quot ' go to a bookmark
If objRange Is Nothing Then
' bookmark not found
Else
objRange.Text = "This used to be a bookmark"
End If
objWord.PrintOut
objWord.ActiveDocument.Close False ' this closes the document WITHOUT saving
objWord.Quit
Set objWord = Nothing ' clean up all garbage
Set objDoc = Nothing
Set objRange = Nothing