Word as a standalone front-end to Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

brian.dingivan@gsa.gov - 18 Mar 2005 19:11 GMT

I want to be able to use a Word document or template as a standalone
front-end to an Access table. I want to set it up so a user would download
the Word document from a public web server, fill out the form and then email
it back. Once I receive it, I want to be able to transfer the ‘data’ to an
Access table. Can this be done and how?

Reply to this Message

Howard Kaikow - 18 Mar 2005 20:34 GMT

Yes.

All you need to do is create/get an Access object within the Word VBA code,
then Word can control/communicate with Access directly.

Signature

http://www.standards.com/; See Howard Kaikow's web site.

> I want to be able to use a Word document or template as a standalone
> front-end to an Access table. I want to set it up so a user would download
> the Word document from a public web server, fill out the form and then email
> it back. Once I receive it, I want to be able to transfer the 'data' to an
> Access table. Can this be done and how?

Reply to this Message

David Sisson - 18 Mar 2005 21:16 GMT

This should get you started.

http://word.mvps.org/faqs/interdev/GetDataFromDB.htm

Reply to this Message