Discussion on:

How do I... Fill Word form fields with Access data?

Is it possible to create an Access database from data entered into word form fields?

i have the same problem
i have word documents i want to transfer them to an access database
did u find any answers??
Help please i need it neccessary

You will need to alter the script to recursively look through a directory and import all .doc files as opposed to manually selecting each one individually...

http://msdn2.microsoft.com/en-us/library/Aa155434(office.10).aspx

Thanks for the link to the MSDN Library code, now after I have set everything up (created table and module in Access, template in Word, and sample completed forms in Word for Acess to import)-- when I try to run the module, every time I get the error:

"-2147467259: Could not use "; file already in use."

Now I have checked to make sure MS Word is closed and the files are not in use... any suggestions?

THANKS in advance!!!

Do you really mean create? Or do you mean, transfer data to an existing Access database? You could do either, but transferring data would certainly be easier.

We've reached our limit of nested replies, so I have to start a new response.

I think the first thing we have to do is define related, so that we're both on the same page with your question. You said that all three tables have a common value, that implies a relationship between the three tables. You should be able to create a multi-join statement that pulls all these records together into a meaningful set of values. It isn't necessary for you to manually create a relationship via Access' Relationship window to make this work.

I've been using the script below with Office 2003 Professional to send data from access 2003 to a Word 2003 doc, with out success.

All I done is change the name of the word fields.

Can anyone offer a solution?

Dim appWord As Word.Application
Dim Doc As Word.Document
On Error Resume Next
Err.Clear

Set appWord = GetObject(, "Word.Application")
If Err.Number 0 Then
Set appWord = New Word.Application
End If

Set Doc = appWord.Documents.Open("H:\SafeCheck\Client file\Customerslip.doc", , True)
With Doc
.FormFields("FldSelExCM").Result = Me!SelExCM
.FormFields("FldSelAddCM").Result = Me!SelAddCM
.Visible = True
.Activate
End With
Set Doc = Nothing
Set appWord = Nothing

Exit Sub

Errhandler:
MsgBox Err.Number & ":" & Err.Description

I would really like to fill out a form in MS Word, and then have the fields in the form populate an Access database. Has anyone tried that?

You will need to alter the script to recursively look through a directory and import all .doc files as opposed to manually selecting each one individually...

http://msdn2.microsoft.com/en-us/library/Aa155434(office.10).aspx

Tell me what's going wrong -- are you getting an error -- what's happening?

At my work we routinely fill out forms with fields that have a set of data choices. For example:

The ball is |__________||. (A drop down menu allows red, white, blue).

I would like to be able to fill out all the blank fields in the form and have the data transfer to an Access database as the last step.

I haven't been able to find any programs that do that.

Do you know of any? Thanks.

Can subform data populate a Word form, too?
I'm setting up my Word form with matching fields from an Access form, but I would really like the sub-form fields to be included as well. Is this possible, please?

Is this code actually for Office 2003, I followed the instruction for List B a few times now and no go.

Could the code be related to an older version of Office/window than XP SP2 and Office 2003?

Yes, the code was written using Office 2003 and Windows XP. Why do you think Windows XP might be a factor?

What kind of error are you getting. I'll try to help you resolve the problem.

The code is for Office 2003. I'll see if I can revise it for 2007.

I too tried the methods mentioned above and was unsuccessful. When I used the Listing A code, I get a Microsoft Visual Basic error "Compile Error: User-defined type not defined" and the code "Dim appWord As Word.Application" is highlighted. I get this error after I click on the print button I created in Access.

When I tried using Listing B code nothing happens. No error, but nothing gets populated in my Word document.

I'm currently running Office 2003.

Please help. Thank you in advance.

Aloha!!!

Great !! but how do you get checkbox's to check- I have an access Form with a checkbox and when the box is checked, i get the value to check the box and the box on the form field does not check - can anyone "check" this out for me please

thank you!

Help I can get the VB to compile but the form comes up with the field names, not the data. Maybe the form is wrong or I need another Reference Library? Here are my VB references:
Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft Word 11.0 Object Library

I have the form - with the "type" as text and the put the "default text" as fldCustomerID on the form. Is this what you meant by "renaming the field fldCustomerID?" There was no picture once I followed the Form properties.

Thank you