How can I place Access data in a Word form?

  • Thread starter Allan V. Pimble
  • Start date
A

Allan V. Pimble

I have client data in an Access database that must be placed into multi-page
Word documents (40 plus pages) and presented to clients for them to sign off
on.

Presently in our office, we receive documents from our clients with a
variety of data. We scan them, and place them in a database on the network.
Everyone prints the documents and then types the data into a Word document
that contains a number of fields. Some other area in the firm is extracting
this data and compiling it for their use.

Because this data must be grouped and summarized in many different ways, I
enter the data into Access first (I am the only staff member that knows
Access and VBA). I would like to be able to transfer this data from Access
directly into the fields of these Word forms. How can I do this?
 
J

Jean-Guy Marcil

Allan V. Pimble was telling us:
Allan V. Pimble nous racontait que :
I have client data in an Access database that must be placed into
multi-page Word documents (40 plus pages) and presented to clients
for them to sign off on.

Presently in our office, we receive documents from our clients with a
variety of data. We scan them, and place them in a database on the
network. Everyone prints the documents and then types the data into a
Word document that contains a number of fields. Some other area in
the firm is extracting this data and compiling it for their use.

Because this data must be grouped and summarized in many different
ways, I enter the data into Access first (I am the only staff member
that knows Access and VBA). I would like to be able to transfer this
data from Access directly into the fields of these Word forms. How
can I do this?

This might help you to get started:
http://word.mvps.org/faqs/interdev/getdatafromdb.htm

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
[email protected]
Word MVP site: http://www.word.mvps.org
 
Top