How can you handle "multipunch" responses in Access?

J

janetdarvish

I apologize for my earlier post. Somehow, the text did not get included....

I am trying to build a questionnaire in Access. One of the questions could
have several potential responses. An example would be, "Of Baskin & Robins
31 flavors, which are your favorite?"

Is there a way to allow multiple answers to this question without having to
set up 31 yes/no boxes for each potential respons? Ideally, I'd like to be
able to make a drop-down box that enables to respondent to "Check all that
apply."
 
J

janetdarvish

I apologize for my earlier post. Somehow, the text did not get included....

I am trying to build a questionnaire in Access. One of the questions could
have several potential responses. An example would be, "Of Baskin & Robins
31 flavors, which are your favorite?"

Is there a way to allow multiple answers to this question without having to
set up 31 yes/no boxes for each potential respons? Ideally, I'd like to be
able to make a drop-down box that enables to respondent to "Check all that
apply."
 
J

John Vinson

I apologize for my earlier post. Somehow, the text did not get included....

I am trying to build a questionnaire in Access. One of the questions could
have several potential responses. An example would be, "Of Baskin & Robins
31 flavors, which are your favorite?"

Is there a way to allow multiple answers to this question without having to
set up 31 yes/no boxes for each potential respons? Ideally, I'd like to be
able to make a drop-down box that enables to respondent to "Check all that
apply."
Click to expand...

This is a classic many to many relationship. There's an old saying
around here - "fields are expensive, records are cheap". You don't
store multiple values in the same record, and *certainly* not in the
same field!

Instead, you need *an additional record* for each reply. The user
would put in a record for Vanilla, a different record for Rocky Road,
and a third for Habanero Chile ice cream, for example.

There's an excellent, fully worked out questionnaire application which
does all this, written by Duane Hookum. Try downloading it from

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

(fix the word wrap before clicking)


John W. Vinson[MVP]
 
J

janetdarvish

Thank you! I had a feeling the first part of your response was the actual
answer. I will try Duane's program as soon as the rogersacess website starts
responding. (Tried multiple times both navigating my way in and using the
link, but it's not responding).

Janet Darvish
 
L

Lynn Trapp

The user would put in a record for Vanilla, a different record for Rocky
Road,
and a third for Habanero Chile ice cream, for example.
Click to expand...

We make Vanilla and a mean Rocky Road, but this new idea of Habanero Chile
ice cream... hmmmmm... not sure that will catch on. <g> There are a few guys
in our IS Department who might like it though. <g>


--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
 
D

Duane Hookom

Janet,
Please don't start "ice cream wars". There are two Access MVPs (Lynn and
myself) who work for companies that together produce a large percentage of
the ice cream sold in the U.S. (and in my case, the world). A discussion on
which is best could soon lead to a nasty thread ;-)
 
L

Lynn Trapp

Please don't start "ice cream wars". There are two Access MVPs (Lynn and
myself) who work for companies that together produce a large percentage of
the ice cream sold in the U.S. (and in my case, the world). A discussion
on which is best could soon lead to a nasty thread ;-)
Click to expand...

"ice cream wars"? Is that anything like a food fight? ;-)

So do y'all make Habenero Chile Ice Cream? <g>

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
 
D

Duane Hookom

We might have something like that in our Stouffers or Hot Pockets divisions
but not ice cream.

This reminds of the old joke about the guy eating the very hot/spicy mexican
food alternating with a spoon of ice cream in between...
 
J

John Vinson

Please don't start "ice cream wars". There are two Access MVPs (Lynn and
myself) who work for companies that together produce a large percentage of
the ice cream sold in the U.S. (and in my case, the world). A discussion on
which is best could soon lead to a nasty thread ;-)
Click to expand...

What!? Injecting habanero chiles into a discussion is starting a flame
war? Who woulda guessed...

We'll just have to get you guys to give us all free samples so we can
determine for ourselves who has the best!

John W. Vinson[MVP]
 
L

Lynn Trapp

L

Lynn Trapp

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

extra table required? 2
how do i put in an animated pic and it be animated in a power poin 1
Access wants password 7
How do I include member photos in a membership database? 0
Some question on access database 3
Is Security Implementations reversable? 4
when i open query i get the message "overflow"? 1
current user- Lynn trapp 4

Top