Hello Lynn,
I'd use automation in the OnClick event of the button:
Dim objWord As Word.Application
Set objWord = CreateObject("Word.Application")
With objWord
.Documents.Open "T:\Individual Risk(IRF)\IRF Input Worksheet
part 2.doc"
.PrintOut
End With
objWord.Quit
Set objWord = Nothing
Watch out for the word wrap (they are all supposed to be single
lines of code) and you'll need to add a reference to Word in your
references.
Hope that helps.
Regards
Robin
--- In [email protected], "Lynn" <[EMAIL PROTECTED]> wrote:
>
> Hi all:
>
> I have a print button that simply prints a record off a form.
Under
> it, I have a hyperlink to: T:\Individual Risk(IRF)\IRF Input
> Worksheet part 2.doc which goes out to MS Word and opens that
> document. I can print it from there.
>
> Is there a way for me to do that programatically...for instance
> every time I hit the print button a MsgBox asks if I'd also like
to
> print the .doc (above) and when I say Yes, it'll do
that 'invisibly'
> for me? I don't need to actually SEE MS Word load every time, so
if
> it could do it behind the scenes, that would be most excellent.
>
> I've looked all over the internet and can't find any instructions
on
> it. Is this possible?
>
> Thanks!
>
> Lynn
> Ball Ground, GA
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
See what's inside the new Yahoo! Groups email.
http://us.click.yahoo.com/2pRQfA/bOaOAA/yQLSAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
