MS Word Forms with access data

[dmposey61]

I have a form created in word that will be emailed to a group of people for them to complete. Part of this same data is already in an access database (name, address, etc). Is there a way to pull in the data from access and automatically update the fields on my word form? I tried using the database toolbar but that just brought in the individual records in rows/columns. I need the data to be imported into the appropriate field(text box) on my form?

I am fairly new to vb coding, so please be specific. If there is a good website to reference, please pass that along also.

I am using MS W2K on XP

Thanks,
dmposey61

 

[Dreamboat]

textbox, yuk.

I've never heard of anybody doing this with anything but bookmarks.

Anne Troy

http://www.amazon.com/exec/obidos/tg/detail/-/0972425845/104-9778384-2391158?v=glance&s=books

 

[ekim]

Dreamboat

Any specific references, resources, FAQs on this technique?.

Someone mentioned 2002 Desktop Developer's Handbook which I have not yet ordered. Would appreciate any more pointers esp on-line resources.

Why "textbox,yuk." ?

 

[torturedmind]

have you tried mail merge from word?

kilroy
philippines

"Illegitimis non carborundum!"

 

[fumei]

Dreamboat is not quite being fair. FormFields ARE bookmarks. If you make a formfield, then look in your list of bookmarks you will see your formfields.

Formfields can be selected by using ActiveDocument.Bookmarks("formfieldname"), but the result is always a property of ActiveDocument.FormFields("formfieldname"). You can use most of the methods of bookmarks on formfields as well. In fact, I think all of them. FormFields are sort of like ASK fields Bookmarks. That is an inside Word joke...never mind.

So. I am not an Access person. However, if you can get the data, you can certainly update the FormField result.

What shows in the formfield (assuming it is a textbox formfield is:

ActiveDocument.FormFields("formfieldName").Result = whatever

"whatever" is a string.

I think Anne's yuk comes from the question - why are you using a formfield if the user is NOT going to be changing the value? FormFields are, generally speaking, used for user input. If you, as developer/designer/whatever are changing values (by whatever means), then the values can be updated using bookmarks. These do not look as......"yukky", as formfields do. At least on screen.

Gerry