I'm not sure this is the correct/best approach, would appreciate help/ideas. I have 2 tables - winetypes and randomwine. Randomwine has autonumberid, as a link to an external picture of wine (.jpg) and a catagoryid. The idea is a user select a style of wine from combobox on form and that somehow w/random function selects from the indexes with the catagoryid being what was selected in the combo box. Any ideas
idea?
- Thread starter teiben
- Start date
I think that will work. I am attaching a db I put together awhile ago in '03 (I know that it doesn't completely work in '07 and not revising it) ...
It is a test program I wrote for a young niece as a study aid and because she liked "playing school" with her friends. Basically, she makes up the questions and answers - inputs those in and then 'takes a test' by selecting a number of questions. The module then randomly selects questions by creating a temporary table. The user selects multiple choice answers and it grades the answers in a report.
I used the Rnd() function (if I recall correctly, it is seeded from the clock so you should get a different selection each time it is run).
The only difference between what you are proposing and what I did is that your random table is prepopulated and mine is temporarily created and destroyed.
There are many ways to do this, I just found one .. and it probably isn't optimized very well. I cranked it out while she was yelling "Is it DONE!?!" and haven't touched it since. Don't know how much it will help, but posting it for your analysis to see if it helps or not.
-dK
It is a test program I wrote for a young niece as a study aid and because she liked "playing school" with her friends. Basically, she makes up the questions and answers - inputs those in and then 'takes a test' by selecting a number of questions. The module then randomly selects questions by creating a temporary table. The user selects multiple choice answers and it grades the answers in a report.
I used the Rnd() function (if I recall correctly, it is seeded from the clock so you should get a different selection each time it is run).
The only difference between what you are proposing and what I did is that your random table is prepopulated and mine is temporarily created and destroyed.
There are many ways to do this, I just found one .. and it probably isn't optimized very well. I cranked it out while she was yelling "Is it DONE!?!" and haven't touched it since. Don't know how much it will help, but posting it for your analysis to see if it helps or not.
-dK
johnwatkins35
Registered User.
- Local time
- Yesterday, 18:40
- Joined
- May 16, 2012
- Messages
- 20
dkinley,
I downloaded your test program database. Im trying to add more answers that are created. 4 gets created im trying to create 6. I was also wondering how to create a printable test that you can print out and take the test that way. Great database by the way.
I downloaded your test program database. Im trying to add more answers that are created. 4 gets created im trying to create 6. I was also wondering how to create a printable test that you can print out and take the test that way. Great database by the way.
- Local time
- Yesterday, 18:40
- Joined
- Aug 30, 2003
- Messages
- 36,157
dkinley hasn't posted in years, so on the off chance they're gone, I'll try. The question table is set up to have 4 answers, so you'd have to add 2 more fields there. The question form would need those fields added to it, as would the test form. Start there and see how it goes. There appears to be a table missing that one of the queries is looking for.
johnwatkins35
Registered User.
- Local time
- Yesterday, 18:40
- Joined
- May 16, 2012
- Messages
- 20
So added those fields to the table, the form, etc. but everytime i hit the button to take the test, the tbltesttable is created with only 4 answers. i think it something in the vba. but i have went through it several times line by line but no luck.
