Because it seems the only way that I can generate a number in one control,
based on a "Yes" or "No" entry in another. And if i try and bind the score
control to the underlying table, i get an error message telling me that
Access 'cannot find a Macro or it has not been saved yet..."
It seems the crucial factor as far as access goes, is that the 'score box'
is a machine generated figure (via Setvalue), rather than a user inputted
figure. I have searched everywhere online, and the only solution deals with a
running total in the footer of a form, and the maths are done by an
underlying query; but again that crucial difference comes up, namely a
running total based on a figure originally inputted as a known figure by the
user. But my form/table does not have a baseline figure to store in the
underlying table for a query to do a calculation on. this is why I am obliged
to use an unbound box.
I tried to fathom out your Survey, but due, in part to it's sheer
versatility, i find it bewildering, and difficult to make the crucial
correlation between your key 'store/bind' the result actions and my fairly
one dimensional 'just store 1 figure each time'. I am simply not in the same
league as you when it comes to complex databases, i can follow a one
dimensional process, but there comes a point where my head just balnks out. I
wish microsoft would incorporate a 'save this SetValue to a table' function,
it would make life much easier for those situations where it's not strictly a
calculated sum.
FYI:
The way my table works is that it comes from an Append query, this in turn
gets its data from a large range of addresses. (1440). Each time the 10
question quiz is finished, the user asks for a new test via a requery. The
questions are random (via a Rnd operator in the query).
Each address in the table has a unique identifier (autonumber) and is
compared to the drop down combo, if they match, the text box say's "Yes', if
they don't, it says "No".
:
I don't know why you are using an unbound form. If you check out the At Your
Survey demo you will see how bind all the user answers. These answers have a
field that identifies the question. Linking to the record containing the
question and answer allows you to easily calculate if the user's answer is
correct.
--
Duane Hookom
Microsoft Access MVP
:
Your suggestion is exactly what is happening now on the form.
The user's answer is being compared to the [Run_point_Address_A field], both
originate from the same table. If I were to do as you suggest, how would I
store the 'answers' in another table?. Maybe I have my teeth in the wrong
bone, but i just can' work out how I can store an unbound data field in a
table?. This seems to me to be the crux of the problem. Even with a query
using something like Ccur, Access assumes that the initial input data to
derive a calculated field comes from a store table field that has been
manually inputted.
I can understand why MS Access doesn't like the idea of storing calculated
fields that can change depending on othr values, but it's not so much a
calculated field as much as it is really a setvalue field. In this case a
constant '1'. I wish Microsoft would recognise that users do sometimes need
to store such fields as they are generated.
:
I would store the users' answers in a table. You can then compare the users'
answer to the Run_point_Address_A field in your original table. If they are
the same, the question was answered correctly. This can all be totalled in a
query.
--
Duane Hookom
Microsoft Access MVP
:
Thanks for the suggestion, but I have tried to understand how and where the
Scores are stored in your program, but just can't get my head 'round it...
Can you just suggest how one gets around the problem of storing a
calulated-generated field, bearing in mind that the field is initially
generated to an unbound box and as such, any underlying query would not know
of its existance in a table.
:
Check out the "At Your Survey" application found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
might get you started. You would need to add a field to a table that
identifies the correct response.
--
Duane Hookom
Microsoft Access MVP
:
Sorry Duane, I didn't realise it was a TableDesign NG, the title say's
'Access Database Design', I took that to mean more general/conceptual
design. But i guess the tables are fundamental to things, so:
The table simply consists of just four fields which serve the exisiting
requirement to display a question and its answer counterpart field.
Run_No: Autonumber
Point_Quiz_ID (Number generated by an append underlying query)
Run_point_Venue_A (This is the question)
Run_point_Address_A (This is the answer)
This table is linked to a form with the Unbound text boxes previously
mentioned. One is the drop-down Combo box, which displays a possible 10
answers to the question. Once the user has selected the correct answer, an
AfterUpdate macro does a SetValue on a Text Field Box setting its value to
either Yes or No.
My problem is that i want to be able to now store the score for number of
questions guessed correctly, but cannot find a way of storing an unbound or
calculated control.
:
This is a tablesdbdesign NG so it would really help if you would share your
table structure.
--
Duane Hookom
Microsoft Access MVP
:
I want to create a scoring system for every time a user gets a correct answer
to a question. (Max 10)
At the moment I am using an unbound text box with a calculated ‘SetValue’
macro to record each correct entry based on a simple Yes or No unbound
answerbox, (which is based on a drop down combo question box) the running
total box is incrementing by 1 each time. So far, this all works fine for
displaying the running score.
But now I need to store the values somewhere, but if I bind the calculated
control to a table field it doesn’t work. So where and HOW would I store the
data if it won’t go in a table?
Can someone give me some general pointers as to what the overall structure
or direction should be to make this work.
