Print a Word document from Access Form

[newcoder54]

I need to have a function that will print a DOC file when I click on a button on a Access 97 form. I suppose Word has to open a bit, print and then close. The file has a specific name in a specific folder. Over my head at this point to do the code. Thanks much!

 

[glalsop]

Try this:

Private Sub Command15_Click()

Application.FollowHyperlink "C:\Documents and Settings\ufga20.000\Desktop\Word1.doc"

End Sub


-Gary

 

[glalsop]

Sorry, didn't thoroughly read you post. The FollowHyperlink solution is a simple one, but will not automatically print and close Word, the user will have to do that manually.

-Gary

 

[Qu2]

You'll have to look at the keystrokes involved with Word but you can use "SendKeys" to try and do the printing and close Word. For example:

Application.FollowHyperlink "C:\Documents and Settings\ufga20.000\Desktop\Word1.doc"

SendKeys "^p" 'Print the document
SendKeys "~" ' Hit enter for the OK button
SendKeys "^q" ' Quit

I'll caution that this isn't pretty, especially on a slow system and can be prone to problems. (Like user interaction when they see Word open.)

Hope it helps.

-Emil