Sending data from an MS-Word 97 form to a MS-Access 97 database

[Charles L. Phillips]

Hello,
I have created a survey form in MS-Word 97.
The form allows Users to enter & select data.
There are "text form fields", "drop-down form fields", & "check
boxes"...

When the User sends this form back to me, I don't want to re-enter
this data...
Is there a way (code) I can create a "submit" button, that will
send this info to the correct fields in the correct database
(MS-Access 97)???

ANY help would be greatly appreciated...

 

[Arvin Meyer]

Tom Wickerath answered this question, just yesterday by pointing the user to
this MSDN article:

http://tinyurl.com/28uny
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Tom Wickerath]

Charles,

I will send an Access 97 version of the sample database, and the accompanying Word
document to your e-mail address. I haven't tried this using Access 97, but I think it
will work.

Tom
______________________________________

Tom Wickerath answered this question, just yesterday by pointing the user to
this MSDN article:

http://tinyurl.com/28uny
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

______________________________________


Hello,
I have created a survey form in MS-Word 97.
The form allows Users to enter & select data.
There are "text form fields", "drop-down form fields", & "check
boxes"...

When the User sends this form back to me, I don't want to re-enter this data...

Is there a way (code) I can create a "submit" button, that will send this info to the
correct fields in the correct database (MS-Access 97)???

ANY help would be greatly appreciated...

 

[Tom Wickerath]

Hold the press! This sample uses ADO code, which will first have to be converted to DAO
code in order to work with Access 97.
Any chance you can use a newer version of Access?
______________________________________


Charles,

I will send an Access 97 version of the sample database, and the accompanying Word
document to your e-mail address. I haven't tried this using Access 97, but I think it
will work.

Tom
______________________________________

Tom Wickerath answered this question, just yesterday by pointing the user to
this MSDN article:

http://tinyurl.com/28uny
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

______________________________________


Hello,
I have created a survey form in MS-Word 97.
The form allows Users to enter & select data.
There are "text form fields", "drop-down form fields", & "check
boxes"...

When the User sends this form back to me, I don't want to re-enter this data...

Is there a way (code) I can create a "submit" button, that will send this info to the
correct fields in the correct database (MS-Access 97)???

ANY help would be greatly appreciated...

 

[Tom Wickerath]

Okay, it seems to be working okay with ADO 2.1, Access 97 and Word 10. I didn't think
that one could use ADO code in versions prior to Access 2000. Learn something new every
day! I will send you a copy.

Tom
______________________________________


Hold the press! This sample uses ADO code, which will first have to be converted to DAO
code in order to work with Access 97.
Any chance you can use a newer version of Access?
______________________________________


Charles,

I will send an Access 97 version of the sample database, and the accompanying Word
document to your e-mail address. I haven't tried this using Access 97, but I think it
will work.

Tom
______________________________________

Tom Wickerath answered this question, just yesterday by pointing the user to
this MSDN article:

http://tinyurl.com/28uny
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

______________________________________


Hello,
I have created a survey form in MS-Word 97.
The form allows Users to enter & select data.
There are "text form fields", "drop-down form fields", & "check
boxes"...

When the User sends this form back to me, I don't want to re-enter this data...

Is there a way (code) I can create a "submit" button, that will send this info to the
correct fields in the correct database (MS-Access 97)???

ANY help would be greatly appreciated...

 

[Tom Wickerath]

Charles,

Send me a private e-mail, which includes a valid e-mail address, if you'd like the sample
files that go with the MSDN article.

This is an automatically generated Delivery Status Notification.

Delivery to the following recipients failed.

(e-mail address removed)


Tom
______________________________________

Okay, it seems to be working okay with ADO 2.1, Access 97 and Word 10. I didn't think
that one could use ADO code in versions prior to Access 2000. Learn something new every
day! I will send you a copy.

Tom
______________________________________


Hold the press! This sample uses ADO code, which will first have to be converted to DAO
code in order to work with Access 97.
Any chance you can use a newer version of Access?
______________________________________


Charles,

I will send an Access 97 version of the sample database, and the accompanying Word
document to your e-mail address. I haven't tried this using Access 97, but I think it
will work.

Tom
______________________________________

Tom Wickerath answered this question, just yesterday by pointing the user to
this MSDN article:

http://tinyurl.com/28uny
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

______________________________________


Hello,
I have created a survey form in MS-Word 97.
The form allows Users to enter & select data.
There are "text form fields", "drop-down form fields", & "check
boxes"...

When the User sends this form back to me, I don't want to re-enter this data...

Is there a way (code) I can create a "submit" button, that will send this info to the
correct fields in the correct database (MS-Access 97)???

ANY help would be greatly appreciated...