Data entry from Word

[Raya]

I want to send to a community a questionaire typed in Word where people have to fill or check several fields and send me the form back. Afterwards I want to enter all the quistionaire fields to a database. How can I do it?
Thank You

 

[Jezebel]

One method would be to create a questionnaire in Word, where people have to
fill or check several fields. Get them to send the form back to you.
Afterwards, enter the data into a database.

Seriously, what are you asking? How to create a form? How to send it to
people? How to get data from Word to a database?

What have you tried so far and what are you having trouble with?

I want to send to a community a questionaire typed in Word where people

have to fill or check several fields and send me the form back. Afterwards I
want to enter all the quistionaire fields to a database. How can I do it?

 

[Raya]

Actually I'm asking How to create a form (but this I can try to do myself), what I don't know is how get data from the forms I'll receive back to a database


----- Raya wrote: -----

I want to send to a community a questionaire typed in Word where people have to fill or check several fields and send me the form back. Afterwards I want to enter all the quistionaire fields to a database. How can I do it?
Thank You

 

[Doug Robbins - Word MVP]

Hi Raya,

While seconding the suggestion to use a userform, though I would use
Document Variables and {DOCVARIABLE} fields rather than bookmarks, you may
also want to look at:

Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

Actually I'm asking How to create a form (but this I can try to do

myself), what I don't know is how get data from the forms I'll receive back
to a database

----- Raya wrote: -----

I want to send to a community a questionaire typed in Word where

people have to fill or check several fields and send me the form back.
Afterwards I want to enter all the quistionaire fields to a database. How
can I do it?

 

[Raya]

Hi J,
Thank yoy so much. I'll be very glad if you'll send me a sample
Raya

 

[Raya]

Hi Doug,
Thank you for your advice
Everything seems more or less clear, except the sequence: ok, I build a form, send it to recepients, who by the way are all over the world, they fill the fields and return the form. So I receive maybe 100-200 forms. Now how do I enter all the data to a database? When do I make the connection to the database? I guess I have to build a button and then revise every form I received and with the click add the data as a new record, but the button must be activated only on entering my password? Is there a more simple way?
Raya

 

[Doug Robbins - Word MVP]

Hi Raya,

What I would do would be to save all of the returned forms in a folder by
themselves and then run batch processing macro over the files in the folder
to extract the values from the document variables in each file and write
them to the appropriate fields in a record that was added to the database.

Some of the code that you will need is buried in the article "How to Find &
ReplaceAll on a Batch of Documents in the Same Folder" at:

http://www.mvps.org/word/FAQs/MacrosVBA/BatchFR.htm

And I think the rest is in the last of the articles to which I referred you.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.


Hope this helps
Doug Robbins - Word MVP

Hi Doug,
Thank you for your advice
Everything seems more or less clear, except the sequence: ok, I build a

form, send it to recepients, who by the way are all over the world, they
fill the fields and return the form. So I receive maybe 100-200 forms. Now
how do I enter all the data to a database? When do I make the connection to
the database? I guess I have to build a button and then revise every form I
received and with the click add the data as a new record, but the button
must be activated only on entering my password? Is there a more simple way?