merging 2 or more forms into one document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

neville21 - 20 Mar 2006 21:21 GMT

Hi I wonder if someone can give me some ideas - am a novice in way beyond my
depth!

I have created a database and use it to populate various specific Word
forms. (Gives a better printout for hospital generated data in letter format)
I now need to have more flexibility in the printout, to take various "sub
forms" as componants for a "main" Word form and then print the main.

ie currently Access populates Word form A and saves and prints the resultant
doc

I now need to programatically control Word Form B with Word Form b1 and/or
b2 and/or b3 .... and then print and save the completed Word Form B. I plan
to have controls on the access form to be able to know which of b1 ,b2 etc to
use.

I had considered opening b1 inserting the data at the various bookmarks then
copying this and opening form B and appending this etc. Seems very clumsy
and there must be a more elegant way!

Thanks in advance to any one who can both make sense of this and help me
with some needed elegence!
Neville

Reply to this Message

Doug Robbins - Word MVP - 20 Mar 2006 22:17 GMT

I would do the whole thing in Access.

However, you may be able to achieve what you are after with the method
described in the article at:

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

But it will almost certainly take a bit to get your head around it.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hi I wonder if someone can give me some ideas - am a novice in way beyond
> my
[quoted text clipped - 25 lines]
> with some needed elegence!
> Neville

Reply to this Message

neville21 - 21 Mar 2006 00:00 GMT

Doug thanks for the thoughts. The link is not really doing what I need and I
have been unable to avoid using Word in oder to get a useful "letter"

I am not really doing a multi record merge but a single record that needs to
get dumped in a document which is much easier to pretty up then a report for
example. This is working well for a single type of record into a single word
form. I have to now work out how to get access to dump a complete record
(consisiting of various subforms) based on various data options (ie different
subforms) without having multipe pre made templates for each of the options.
To use the naming I had eariler - Form B with b1 and b2 component etc
relating to Subform (in Access) b1 and b2 etc instead of making up a Word
form B1 and another B2 depending on the various Access subform options (b1
,b2 etc)

If that makes any sense at all!

Any help appreciated

Neville

> I would do the whole thing in Access.
>
[quoted text clipped - 34 lines]
> > with some needed elegence!
> > Neville

Reply to this Message