Create submit button to trx to Access

[Highlander]

I have created a form in word and would like a "Submit Data" button to
transfer all the data from the form to an access table in a database. I'm
being a bit adventurous as I am a new user and have no idea where to begin.
Can anyone help me through step by step?

 

[Stephanie Krieger]

Hi,

I suspect this won't be what you're hoping to get in an
answer ... but this is a daunting task for a VBA beginner.

First of all, it's going to require programming knowledge
in both Word and Access. And, if you're in Word 2003
(even earlier versions, but 2003 is the best for this) --
your best bet is to use XML to transfer the data, which
is quite a bit more to learn.

If you do want to take this task on ... start with the
MSDN Library. It's how I started learning VBA (and how
many people do), and like most Office developers, I go
back all the time for help with new tasks. Here's a link
to a bunch of code samples for programming in Access 2002
and 2003, including one that teaches you how to control
one program from another through VBA, which is part of
what you want to do:

http://msdn.microsoft.com/office/understanding/access/code
samples/default.aspx

Also, just a side note ... if you are in Office 2003 and
it happens to be Office Professional enterprise edition
that your company uses, you also might want to check out
a program called InfoPath. While you'll still need
programming skills (and XML knowledge) to get your data
from InfoPath forms into Access, InfoPath is all about
forms and connecting the programs of the Office System --
so you'll find a lot of help at MSDN for getting that
done.


I hope that's useful.

Best,
Stephanie Krieger
author of Microsoft Office Document Designer
blog: arouet.net

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?SGlnaGxhbmRlcg==?=,

I have created a form in word and would like a "Submit Data" button to
transfer all the data from the form to an access table in a database. I'm
being a bit adventurous as I am a new user and have no idea where to begin.

In the Mail Merge section of my website, in the "Special" section, you should
find a link to a file WdAcc97.zip. This has sample code for
Access->Word/Word (form)->Access (as an alternative to mail merge). That
might get you started...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail