Pushing data from Access to Word

[Razor]

Hi,

I have a report that is launched via a form.

The report has three totals in its footer.

How would I use Automation to do the following:

1. access the totals in the report footer,
2. perform some simple math on each total
3. insert the final numbers into bookmarks on a Word
template file (.dot)

Also, could someone point me to any explanatory materials
on Office automation, particularly on pushing data from
Access to Word.

Thanks a lot!

Regards,
Razor

 

[Cindy Meister -WordMVP-]

Hi Razor,

3. insert the final numbers into bookmarks on a Word
template file (.dot)

Also, could someone point me to any explanatory materials
on Office automation, particularly on pushing data from
Access to Word.

I can't help you with 1 & 2; you may need to ask in an
Access-specific group about that.

You'll find WdAcc97.zip on my website, in the "Special
merges" section of the mail merge FAQ. It's a bit out-dated,
but does contain what you need about "pushing data into
Word". Things haven't changed since this was written, really


Although I do explore alternate paths (doc variables, doc
properties, etc.) in an article published in "Smart Access"
a couple of years ago.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail