Albert Kallal - Merge to Word

[Guest]

Is there any way of merging the data from a sub-form into a word document so
that only the sub set information is displayed for the main record.

To expand, I conduct surveys of drainage systems and have codes for all the
defects contained therein in e.g.

"Main Record"
Line 1
Survey from: Manhole 1
Direction: Downstream
Survey to: Manhole 2
Length: 12m
Pipe Diam: 110mm

subset data

Observation Distance
Start 0.0m
Roots 1.0m
Collapse 5.2m
Roots 7.6m
Junction 9.3m
Manhole 2 12.0m
Survey End 12.0m

I would also like to display upto 4 "Main Records" on the merged document in
4 columns with all the corresponding sub data shown below each corresponding
column.

Is this possible and what programming do I need for the Access portion of
this and what for the Word section.

I have posted this to both the Access and Word Forums as the issues I
believe are specific to both programmes.

Thanking you in anticpation.

PMK

 

[Albert D.Kallal]

Is there any way of merging the data from a sub-form into a word document
so
that only the sub set information is displayed for the main record.

My setup does not support a "many" merge.

the solutions are to build a report. You can then while viewing a report,
send it to word....

There are some examples of merging the "many" side into word here:

http://homepage.swissonline.ch/cindymeister/MergFram.htm

and

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm

 

[Guest]

Albert,

as always my undying gratitude

regards

PMK