receiving data for Access via Word fields

[SonicX]

Is it possible and if so is it already integrated or do
you have to programaticly do it with VBA...?

To send a word template with text boxes as an email
attachment and have the person fill out the template and
then return it once recieved update your access DB with
the received text box information?

I am a web programmer and would normally do it with online
forms. It seems a hastle to output a CSV from the Word doc
data and then import that into access. I am thinking that
the only way is to programaticly automate it with an
access app. The user once they received the word doc
attachment with the text fields filled in would save that
attachment to a certain folder and then open access and
the program would direct them to the folder which the
attach doc was saved in. The access app would have to
parse through the word doc using word doc object oriented
methods to get the text field data and then store the data
to it's database.

Any thoughts and suggestions would help Thanks..

 

[Jezebel]

You can code it using VBA at the Access and or at the Word end. It's about
the same amount of coding either way. Open the document, open the database,
pull the data from the form fields, update database. Start by reading up on
form fields (you don't need to parse the document).

 

[Doug Robbins - Word MVP]

Hi SonicX,

See the last of the following series of articles:

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

 

[SonicX]

Thanks that really helped..
This app that somebody was using had a lot of wordbasic
commands..