survey page

[paulhthr]

I am newto Access and am trying the following:
I want to post a survey with option boxes. i would like the option boxes to
be counted in a database so it can correlate the results.
What is the best appraoch for this?
Thank you for any help you can give me.
Paul, NY

 

[John W. Vinson]

I am newto Access and am trying the following:
I want to post a survey with option boxes. i would like the option boxes to
be counted in a database so it can correlate the results.
What is the best appraoch for this?
Thank you for any help you can give me.
Paul, NY

First:

Data is NOT stored in forms.
Fields are NOT stored in option boxes.

Forms and option boxes and other controls are *tools* which let you manipulate
data stored in a Table. The Tables are fundamental, and tables consist of
fields storing Text, Number, Date and other types of data. Tables do not
(should not, anyway, Microsoft's misguided blandishments to the contrary
notwithstanding) contain controls such as Option Groups; they store *data*.

For survey data you may want to look at Duane Hookum's At Your Survey sample
database:

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

and you may want to explain what you mean by "post".

John W. Vinson [MVP]

 

[paulhthr]

Thanks for the reply John.
First, I tried the link you sent me
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000
and I don't understand what it is-it is not a sample survey form.
Second, by post I mean I want to put a survey that is available online at my
website and when the participant submits it, the yes/no answers are
submitted to a database for summing.

 

[John W. Vinson]

Thanks for the reply John.
First, I tried the link you sent me
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000
and I don't understand what it is-it is not a sample survey form.
Second, by post I mean I want to put a survey that is available online at my
website and when the participant submits it, the yes/no answers are
submitted to a database for summing.

I would suggest you look on a newsgroup for whatever webpage editor software
you're using. You *might* end up STORING the survey results in a Microsoft
Access database - but Access, by itself, is not suitable for putting up online
web pages.

John W. Vinson [MVP]

 

[paulhthr]

Thank you for that. I am using Frontpage. I made the survey form in Frontpage
and now I needthe results of the survey to be stored when they are submitted
to an Access database. I am sorry I was not clear earlier-I am probably using
the wrong terminology. Can you explain how to link the Frontpage form to the
database to store the inputted information. For example when the survey
taker submits the form, I want the database to store what was checked in the
option box--1 yes, 2 no, 3 not, etc. I have made a table with the potential
option of the form, one per column.
Again thank you for all your help.
paul

 

[John W. Vinson]

Thank you for that. I am using Frontpage. I made the survey form in Frontpage
and now I needthe results of the survey to be stored when they are submitted
to an Access database. I am sorry I was not clear earlier-I am probably using
the wrong terminology. Can you explain how to link the Frontpage form to the
database to store the inputted information. For example when the survey
taker submits the form, I want the database to store what was checked in the
option box--1 yes, 2 no, 3 not, etc. I have made a table with the potential
option of the form, one per column.

You will have to write code (VBScript, probably) on your Form to open a
Recordset in the database and update it. I'm sorry, but that's not something
I've ever done! You really would probably get better information in a
FrontPage newsgroup; or repost here with a subject line such as "How to get
data from webpage into Access".

Note that most web enabled databases use SQL/Server or MySQL rather than
Access, though (again, not from personal experience) I know that Access can be
used.

John W. Vinson [MVP]

 

[John W. Vinson]

You may want to look at the following white paper at the MS Front Page site:

http://www.microsoftfrontpage.com/content/articles/dbpower.html

Thanks, jwm - I may need this myself at some point!

John W. Vinson [MVP]

 

[jwm]

I haven't used Front Page in several years, but I seem to recollect that it
had a built in capability, using its form building tools, to link to an
Access database thru the Front Page extensions.

Have you searched the Help files from within Front Page?

Of course, the above assumes your web host supports the Front Page
extensions.

 

[jwm]

You may want to look at the following white paper at the MS Front Page site:

http://www.microsoftfrontpage.com/content/articles/dbpower.html

 

[jwm]

Hi John:

Glad to have helped, when you read it you'll understand why Front Page was
discontinued. LOL

jwm