Update excel, sql server from a word form?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jereviscious - 05 Apr 2007 17:47 GMT

Hello,

I was wondering if it was possible to update a database from a word
document.

What I want to do is set up an RGA Form (Return Goods Authorization Form).
When the user opens the document, it will start a new record. After they
fill out the form, they can press a "Save" button and it will save all of
the filled out fields into a database.

I'd also like them to be able to select a record from a database and have it
pull up the correct word document.

Possible? Any estimates on programming time? thanks...

Reply to this Message

Doug Robbins - Word MVP - 05 Apr 2007 19:10 GMT

See the last of the following series of articles by fellow MVP Diane Chapman

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

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Hello,
>
[quoted text clipped - 10 lines]
>
> Possible? Any estimates on programming time? thanks...

Reply to this Message