Results 1 to 5 of 5

Thread: Word Forms

  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Indiana, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Word Forms

    Word and Access 97.

    Is there a way to use a word form as a survey-type form and have the information from the form downloaded into Access 97?

  2. #2
    BAM
    Guest

    Re: Word Forms

    Hi LonnieB,

    If you are interested in an automated method from a developers stantpoint, then Cindy Meister, MS Word MVP describes how to accomplish this in this article:
    <A target="_blank" HREF=http://msdn.microsoft.com/library/periodic/period00/MailMergePartI.htm>http://msdn.microsoft.com/library/periodic...lMergePartI.htm</A>

    If you aren't want a less advanced method then the data entered into the form fields can be saved as a CSV format. The CSV format option is found under Tools/Options/Save and "Save data only for forms"

    You could also create a type of "master" document to accumulate the CSV files/records. When you save only the data from the completed form the result is a single record in the CSV format.

    To automate this task you could create a macro and run it for each completed form that:
    - Turns on the "Save data..." option
    - Saves document with a specific file name
    - Inserts the contents of the CSV file into the "master" document

    This document can then be easily imported into Access. You could automate that as well with a macro that imports the data and then deletes the "master" document contents so the first process can be started over again.
    ~~~~~~~~~~~
    Cheers!

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Indiana, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word Forms

    Thanks for the response. I looked at Cindy Meister's article. From what I read and understood, she is only talking about getting data from Access into a Word merge document. I am looking for the opposite.

    I will try the CSV method tomorrow.

    Again, thanks.

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Word Forms

    I realize this doesn't involve Word, but online survey sites allows you to create a pretty attractive survey and get the results in a spreadsheet format. Fast PCs and connections are preferable due to complex code. Here's a sample Zoomerang survey: <A target="_blank" HREF=http://www.zoomerang.com/survey.zgi?XK596CVX1YJJ8FV9BW0RC7BA>Rate the Boss Evaluation Form</A>

  5. #5
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,049
    Thanks
    124
    Thanked 119 Times in 116 Posts

    Re: Word Forms

    This sounds like it can be done but you might be better off using a web form. That is because a web form is designed to send information to a database.

    Word forms can be set to save only the data in the fields. You would then be harvesting this from individual documents using Access.

    I would suggest posing your question to the Access and VBA groups.
    Charles Kyle Kenyon
    Madison, Wisconsin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •