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
(e-mail address removed)
Word MVP site: http://www.word.mvps.org
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top