Can anyone answer this for me?
--- In [email protected], "Lynn" <[EMAIL PROTECTED]> wrote: > > > 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 the word doc? (in conjunction with the underlying form) and if yes", it does what you outlined below. If "no", it simply prints the form and not the word doc? > What would that look like? :) Big thanks again, > > Lynn > Ball Ground, GA > > --- In [email protected], "Robin" <falconer5@> 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 Sponsor --------------------~--> Check out the new improvements in Yahoo! Groups email. http://us.click.yahoo.com/7EuRwD/fOaOAA/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/
