Populating Access table from a userform in word 2003 VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ras123 - 22 May 2006 16:47 GMT

Dear All,

Please could you point me in the right direction of populating an access
table from a userform in word.

E.g

Word form has 2 text boxes 1 + 2
Access table has 2 fields 1 + 2

When a user updates the userform in word and hits a submit button I want this
information to be stored in the access table.

Hope this makes sense

Thanks in advance for any help

Simon

Reply to this Message

Doug Robbins - Word MVP - 22 May 2006 18:33 GMT

See the last article in this series

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

> Dear All,
>
[quoted text clipped - 15 lines]
>
> Simon

Reply to this Message

ras123 - 23 May 2006 13:16 GMT

Many thanks for the links they are a great help?

>See the last article in this series
>
[quoted text clipped - 20 lines]
>>
>> Simon

Reply to this Message