How can you handle "multipunch" responses in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
On Fri, 19 Aug 2005 10:00:04 -0700, janetdarvish

Janet, if you have a question, please ask it in the text area, not
just the subject line; and provide enough context that someone might
possibly be able to understand what you need. "Multipunch" applies to
punchcards and punched paper tape, which I'm old enough (just) to
remember, but they had become obsolete before Access 1.0 was released.
The term means nothing to me in an Access context.

John W. Vinson[MVP]
 
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."
 
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."
 
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]
 
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
 
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
 
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 ;-)
 
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
 
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...
 
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]
 
Back
Top