Microsoft Word linking to Access Database Help.

[SSJpn]

At work we have to fill in forms written up in Word and we also have to put that same information into our Access Database. Is there a way that we can link the two so that as we are filling in the WORD form our data base is also being simultaneously updated?

Thanks.

 

[Scoty]

This may not be a direct response to your question. But couldn't you just build the form in Access and print it. Then you database would be filled in as well?

jmtc
Scoty : "Learn from others' mistakes. You could not live long enough to make them all yourself."
-- Hyman George Rickover (1900-86),

 

[AlexBeet]

How do you use your Word form? Do you simply enter information into the form and then print it or save it?
If this is the case, the easiest solution is to simply enter the information into the access database first, and then setup a Mail merge document in Word with a connection to the Access database - you can then use a mail merge query to print any of the records you wish - you could perform one mail merge for all entries in each day.

However, if you still wish to enter the information into Word first, it is quite easy to send the data to an Access database - How this is performed depends on how your Word form is set up - i.e Is it set up as a true form with form fields, or is it a basic form created with a table, or do you just use a word document to hold a list of data?
Is the Access database available to you from your computer? ie Is it networked or held locally on your PC?

 

[SSJpn]

AlexBeet -

Currently the form is just a basic form created with tables etc. (its not a true form with form fields). I like this mail merge idea. Say I enter in 10 records to the data base, can I set it up so that the mail merge thing will make 10 sets of documents and print each one? Or do I have to go 1 record at a time and mail merge and print...

 

[SSJpn]

Actually the WORD document needs to be filled out first and then some of the information needs to be stored into our database. The database is on the same computer as the WORD form. Currently the WORD form is a basic form with tables. But if its easier to make true forms then I will do that.