Has anyone created a questionnaire(survey) application ?

[FrustratedStudent]

I have created an application that allows users to answer a series of questions and print reports based on that data.

Currently, on my data entry form the user has to save after each answer they give. I can't find another way of making this form work. If anyone has a idea or has done this before please respond

 

[JerSand]

Hello.

I've created several questionnaire applications. Usually, the key to automatically saving records/entries lays in some fairly easy-to-use macros.

Could you give me a bit more information about what happens when the user does not save after each entry? At what point do you discover that the item (and, I assume, the whole record) has not been saved?

One further question: Is this a paginated form?

jersand

 

[FrustratedStudent]

I have the form set up with the registration information set up at the top of the form and then a subform to view the form which actually holds the questions.

The subform has a tab control on it and each page contains a listbox with the questions relevant to each section (the questionaire has 7 sections). The user has to select a question from the listbox and respond in a text box that I placed on the form and then they have to push a command button that says "Save Response". As you can tell this process is a bit much for the average user

( all questions need to be answered and if the user doesnt enter one the question will not show on the final report)

Another issue is that most of the answers have several options for the answer and I need to display them.

Let me know if you need further explanation of my form

FRUSTRATED STUDENT

 

[JerSand]

Hi, FrustratedStudent.

I'm sorry for the delay; my LAN has been down.

Since reading your response, I've experimented a little with what seems to me to be approximations of your form. At present, I'm stumped regarding why yours requires the "save response" command button after each entry. However, here's one possible fix that would require a little design rework.

1. Create a macro that saves the table. This would be a one-line macro: the action would be "Save" and the lower (arguments) part would specify table and the table name.
2. Attach the macro to each text box's "On Lost Focus" or "On Exit" property line.

This seems like overkill, but without a closer look at what's happening, it's all I can think of so far. If you'd like me to examine the actual form, you could send a copy of the whole database to me at:

sandauj.ggd@gao.gov

Regarding the issue of displaying answer options: It sounds like a straightforward matter of either defining the pertinent table fields as lookup types or directly creating combo boxes on the form and attaching them to the appropriate control sources. However, this would not be the case if these are check-all-that-apply series of questions. In that case, it might be better to disaggregate the items as a series of yes/no responses.

I'm sorry I'm not "getting it" based on our exchange so far.

JerSand

 

[JerSand]

Hi, FrustratedStudent,

I received the picture; thanks. Your form seems pretty sophisticated.

I fear I'm wasting your time; your form is far different from anything I've designed. Nevertheless, here goes -- some questions regarding points on which I'd need clarification to figure-out why your approach requires a Save for each entry.

Here's what I infer from the picture:

The subform is a based either on a single table or, alternatively, on a query, with each tab based on part of the query.

The user sometimes (always?) must use each page more than once for a single record. For instance, if the answer to the first question were yes, the user would return to answer the second question.

Each question corresponds to a unique table or query field, and the response should get entered in that field.

The Response text box looks like it's not a list box, and since it's clearly not a combo box, the user must type-in the answer.

If these inferences are right, then I guess my basic question pertains to table/query structure and how the response box is tied to it. If there's only one response box per page, how does the answer get directed into the appropriate field when the respondent has to use the page more than once?

To answer your about whether I hard-coded the questions: Yes. Unlike yours, my questionnaire/survey forms were meant to be used only once.

JerSand