YES! Thank you SO MUCH, Robin, that worked perfectly....now can I throw another one at ya?
What if I want a box to come up that says, Do you want to print this word doc (in conjunction with the underlying form) and if "yes", it does what you outlined below. If "no", it simply prints the underlying form? What would that look like? :) Big thanks again, Lynn Ball Ground, GA --- In [email protected], "Robin" <[EMAIL PROTECTED]> wrote: > > 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" <winpins@> 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 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/
