I am glad Dawn answered this one. I tried three times to answer last night and my posts went nowhere. I would have been upset if Lynn did not get the help she required just 'cause Yahoo stuffed up.
Pity about all the time I wasted. Regards Robin --- In [email protected], "Lynn" <[EMAIL PROTECTED]> wrote: > > Can anyone answer this for me? > > > --- In [email protected], "Lynn" <winpins@> 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 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/
