Simple Questionnaire DB

[scubadiver]

Hello,

Tina sent me a demo of a db she did and it is perfect for what you need. If
you let me have your email address I will send it but don't write the email
correctly (ie use "dot" instead of "." and "at" instead of @). So spam
software doesn't find it

 

[Pixie78]

Thanks scuba, I'm working on 3 databases so my mind goes fuzzy sometimes
trying to figure out how to make things go. =p And this survey business
isn't crucial, it's just an easy out for me when it comes time to count so I
can spend more time building the other databases!!

bruja (under score) leslie at hot mail dot com
~No spaces~
Thanks so much!

 

[John W. Vinson]

Hello,

Tina sent me a demo of a db she did and it is perfect for what you need.

Thanks, scubadiver. If you and Tina are both on the case I can relax - she's
in good hands!

John W. Vinson [MVP]

 

[scubadiver]

Can you answer the queries in my last message?

Thanks, scubadiver. If you and Tina are both on the case I can relax - she's
in good hands!

John W. Vinson [MVP]

 

[scubadiver]

Put the following in the "on change" event of the [answer] field in the
subform.


If Me.CurrentRecord < Me.Recordset.RecordCount Then

If Len(Me![detailAmount].Text) > 0 Then
DoCmd.GoToRecord , , acNext
End If
End If



When you enter an answer the cursor will tab to the same field in the next
record. When you get to the last record the code doesn't bug out.

 

[scubadiver]

Sorry, when I said last message I meant my final message (ie third from
bottom in the list!).

I do have two remaining

1) I do have some text answers (like open comments). Should the [answer]
field be changed to a text field or will this cause problems with queries etc?

2) How can I deal with a question that can have multiple responses?

3) How I can deal with any questions that are non-numeric (like check boxes)?

Cheers

 

[John W. Vinson]

Sorry, when I said last message I meant my final message (ie third from
bottom in the list!).

I do have two remaining

1) I do have some text answers (like open comments). Should the [answer]
field be changed to a text field or will this cause problems with queries etc?

You will need to be consistant - all number or all text - or else have two or
more answer fields: one text answer, one number answer, one date answer, maybe
one yes/no answer. This gets complicated because you need some way to prevent
entry of multiple answers in each question.

2) How can I deal with a question that can have multiple responses?

Another table related one to many to the answers table.

3) How I can deal with any questions that are non-numeric (like check boxes)?

Checkboxes *are* numeric... 0 is unchecked, -1 is checked - but see the answer
to 1.

John W. Vinson [MVP]