Possible to have repeating section of bookmarks in word template??

D

Doug Goodenough

Hi,

I have an existing word template with bookmarks that I am sending data to
from my access application. The users have now asked me to include data
from a child table that can have 0 - many records in it for each parent
record. Is there a way to loop thru the records in the child table and have
word repeat a section for each of these records? If not any other ideas on
the how this might be done?

Thx very much,
Doug
 
S

Steve

Give us an example of your Word doc and what you mean by Section.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
D

Doug Goodenough

Hi Steve,

The Word template is made up of several tables. In the cells of the tables
are the titles of the various fields I am sending from the Access
application along with the associated bookmarks.

The data that I would want to display from 1 to N times would be in another
table in the word template.

I hope that helps.

Thx,
Doug
 
P

pietlinden

Sounds like you're describing something like an invoice, where the
header info comes from one source and the content of the "subform"/
line items comes from another. There's an example in Access Desktop
Developer's Handbook. IIRC, you pass the child/subform data as an ADO
recordset that gets turned into a delimited recordset. Then you
convert it to a table with Word VBA.
 
Top