p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Survey Form


Message #1 by "niraj sharma" <nsharma@y...> on Sat, 23 Jun 2001 17:09:11

I am trying to design a survey with about 100 questions.

I would like to break the survey down into 10 pages of

10 questions each and have a continue button at the bottom

of each page. Finally, I would like to insert the results

into the database. I would also like for the user to be able

to go back to previous questions while retaining their 

answers so they can make changes if necessary



Anyone worked on a similar project?? If so, I would appreciate

your help...
Message #2 by Brian Skelton <brian.skelton@b...> on Sun, 24 Jun 2001 01:40:24 +0100
The easiest way to do this would be to have one MASSIVE form containing 

boxes to hold the answers to all your survey questions, and then break 

it into ten pages using the pagebreak control. You'd have a 'next' and 

'previous' button on each page to move the focus between pages and an 

'accept button on the final page to write the data to the database.



Look up 'Create a form with more than one page (screen)' in the Access 

help - I think there's even an example in the Northwind database.



-BDS





I am trying to design a survey with about 100 questions.

I would like to break the survey down into 10 pages of

10 questions each and have a continue button at the bottom

of each page. Finally, I would like to insert the results

into the database. I would also like for the user to be able

to go back to previous questions while retaining their

answers so they can make changes if necessary



Anyone worked on a similar project?? If so, I would appreciate

your help...











Message #3 by Walt Morgan <wmorgan@s...> on Sat, 23 Jun 2001 13:48:06 -0500
You may wish to consider creating the number of forms required for your

survey and add a multiline textbox for each response. The questions could be

labels on the forms. Add a next and a previous command button to move

between the forms and have a save command button and a cancel command

button.



Of course, you would have created an access table with fields large enough

to handle the expected responses by question number. When the save command

button is clicked it would append the form data into a record in the table.



With reporting in mind you may also wish to consider an index on each

question so that resulting reports could display all responses to a

particular question. Which would mitigate offering discrete responses e.g.,

your answer is: (1 2 3 4). Free form text answers are not easy to make sense

of.



Hope this helps somewhat.



Walt Morgan



Message #4 by "Bob Bedell" <bdbedell@m...> on Sat, 23 Jun 2001 19:06:52 -0400
Ya' gotta' check out Duane Hookom's fabulous survey definition and reporting 

application at rogersaccesslibrary.com/duanehookom/duanehookom.htm. Best 

open source code "sample" Access app I ever came across. The app is called 

At Your Survey (ATS) and you can download it for free. But as Duane says, 

"Steal ideas and methods but not the whole of the application." In other 

words, you can't distribute it. See what ya' think.



>From: "niraj sharma" <nsharma@y...>

>Reply-To: "Access" <access@p...>

>To: "Access" <access@p...>

>Subject: [access] Survey Form

>Date: Sat, 23 Jun 2001 17:09:11

>

>I am trying to design a survey with about 100 questions.

>I would like to break the survey down into 10 pages of

>10 questions each and have a continue button at the bottom

>of each page. Finally, I would like to insert the results

>into the database. I would also like for the user to be able

>to go back to previous questions while retaining their

>answers so they can make changes if necessary

>

>Anyone worked on a similar project?? If so, I would appreciate

>your help...





Message #5 by "Pritesh" <pritesh_b@t...> on Sun, 24 Jun 2001 09:01:55 +0100
Are you trying to design a web based or application based questionnaire?



-----Original Message-----

From: niraj sharma [mailto:nsharma@y...]

Sent: 23 June 2001 17:09

To: Access

Subject: [access] Survey Form







I am trying to design a survey with about 100 questions.

I would like to break the survey down into 10 pages of

10 questions each and have a continue button at the bottom

of each page. Finally, I would like to insert the results

into the database. I would also like for the user to be able

to go back to previous questions while retaining their 

answers so they can make changes if necessary



Anyone worked on a similar project?? If so, I would appreciate

your help...







Message #6 by "niraj sharma" <nsharma@y...> on Mon, 25 Jun 2001 03:23:36

Web Based!



> Are you trying to design a web based or application based questionnaire?

> 

> -----Original Message-----

> From: niraj sharma [mailto:nsharma@y...]

> Sent: 23 June 2001 17:09

> To: Access

> Subject: [access] Survey Form

> 

> 

> 

> I am trying to design a survey with about 100 questions.

> I would like to break the survey down into 10 pages of

> 10 questions each and have a continue button at the bottom

> of each page. Finally, I would like to insert the results

> into the database. I would also like for the user to be able

> to go back to previous questions while retaining their 

> answers so they can make changes if necessary

> 

> Anyone worked on a similar project?? If so, I would appreciate

> your help...

> 

> 

> 

Message #7 by "niraj sharma" <nsharma@y...> on Mon, 25 Jun 2001 03:24:28
Isn't that a stand-alone application..meaning it's

not web-based, right?



> Ya' gotta' check out Duane Hookom's fabulous survey definition and 

reporting 

> application at rogersaccesslibrary.com/duanehookom/duanehookom.htm. Best 

> open source code "sample" Access app I ever came across. The app is 

called 

> At Your Survey (ATS) and you can download it for free. But as Duane 

says, 

> "Steal ideas and methods but not the whole of the application." In other 

> words, you can't distribute it. See what ya' think.

> 

> >From: "niraj sharma" <nsharma@y...>

> >Reply-To: "Access" <access@p...>

> >To: "Access" <access@p...>

> >Subject: [access] Survey Form

> >Date: Sat, 23 Jun 2001 17:09:11

> >

> >I am trying to design a survey with about 100 questions.

> >I would like to break the survey down into 10 pages of

> >10 questions each and have a continue button at the bottom

> >of each page. Finally, I would like to insert the results

> >into the database. I would also like for the user to be able

> >to go back to previous questions while retaining their

> >answers so they can make changes if necessary

> >

> >Anyone worked on a similar project?? If so, I would appreciate

> >your help...

> 

> 


  Return to Index