The user needs to be able to select only one of the five statements
for each category. I then need the statement to be transalted into a
number (1-5) to be used for scoring.
Okay, how about setting up an option group to handle this? The option group
(aka "radio buttons") will only allow a single option to be selected within
the group. You can assign numeric values to each option button, such as 1-5,
and store these in the control source for the option group. The translation
is handled automajically for you.
I also need the form to be set up so that only one category and its
five respective options show. Then have a button that will lead to the
next category.
Without knowing the design of your database, my first impulse is to say use
a bound form that displays one record at a time. I think I'd set the visible
property to no for the built-in navigation buttons, and create a forward only
button using the appropriate code (or perhaps you'd want to allow the user to
go back to a previous question also?). The code behind this button would
likely close this form and open a "Thank You for taking this survey" form
when the user was sitting on the last record in the recordset, and they
clicked on the button.
Hmmm.....perhaps you might want to try this sample:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnovba00/html/OfficeKiosk.asp
I believe I have a copy of the sample database that was available several
years ago, but seems to no longer be available. Let me know if you are
interested in receiving a copy. I have shown an obfuscated form of my e-mail
address below. Whatever you do, please do not post your real e-mail address
to any newsgroup message.....unless you love receiving endless spam messages.
I'm going off-line now for the next 7 hours or so.
Tom
QWaos168@XScom cast. Dnet (<--Remove all capitalized letters and spaces).
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
:
Tom--I have looked at Duane's "At your survey." However, I am still having
trouble figuring out how to link my table with my form.
__________________________________________
:
Have you checked out Duane Hookom's "At Your Survey" sample database? I've
only looked at it briefly, but you might find this sample helpful for your
development efforts.
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane
If my answer has helped you, please answer yes to the question that reads
"Did this post answer the question?" at the bottom of the message thread.
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
:
I am designing a survey that will be used for staff development. I have 9
categories with each category having 5 statements to choose from. The user
needs to be able to select only one of the five statements for each category.
I then need the statement to be transalted into a number (1-5) to be used for
scoring. I also need the form to be set up so that only one category and its
five respective options show. Then have a button that will lead to the next
category.
Here is where my problem is...I can't seem to figure out how to set up the
table so the number shows in a way in which it can be used for scoring. I am
also having trouble with the set up of the form. Any advise that you can
offer would be greatly appreciated.
Thank you
