How to print a word document from an Access Form

[Guest_imported]

hi
I have a form with a print command button. I need this one page word document to print if someone hits the print button. I tried to add the word document to the form but there is a lot of text involved. I tried the shell command in VBA but it only opens up the word document in Word. I am running ACCESS 97, I dont know what command to use so if they hit the print button, the form plus the document would print. Please help.... Thanks... Munaf

 

[RSi2]

Dim oApp As Word.Application
Dim oDoc As Word.Document
Set oApp = CreateObject("Word.Application&quot

oApp.Documents.Open ("mydoc.doc&quot
Set oDoc = oApp.ActiveDocument
oDoc.PrintPreview 'oDoc.Print
oDoc.Close
oApp.Quit

 

[Guest_imported]

I tried running the code and I am getting this error message "User-defined type not defined". Any ideas!! Appreciate it...Munaf

 

[Guest_imported]

Munaf Kas (Visitor) Aug 7, 2002
I tried running the code and I am getting this error message "User-defined type not defined". Any ideas!! Appreciate it...Munaf