Word on-the-fly from Access??

  • Thread starter Thread starter 10JQKA
  • Start date Start date
1

10JQKA

Hello:

I have a bunch of data contained in about 15 tables. I need to use
data in the tables to create a fairly complex on-the-fly word
document. The document needs to
have things like:

Sections of text included/excluded
Changes in pluraility (ie. house or houses)
Complex nested tables.
Running figure numbers based on what was inclded or skipped
Intelligent page breaks
renumbering of the table of contents
etc...

The final document seems to be too fluid to create a simple template
and use a mail-merge type approch. The final product has to be in
word (or rtf) format.

How would you attack a problem like this?

Thanks.
 
I would design the pieces of functionality in Word and get the bugs pretty
well ironed out as far as the concepts and the execution. I would then move
the VBA from Word over to a module in Access and start putting it together
with the data in the database.

HTH
 
Back
Top