Thanks so much for trying, Robin! I received Dawn's suggestion yesterday, messed around with it this morning and BINGO, works perfectly, just like I wanted.
You guys are always so helpful! THANK YOU! Lynn Ball Ground, GA --- In [email protected], "Robin" <[EMAIL PROTECTED]> wrote: > > 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" <winpins@> 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/
