Hello all.
Here's the backstory: I'm in the process of putting together a series of clues, physical challenges and locked 'treasure boxes' and the like as a series of 'quests' for my grandkids (aged 10 and under). I have cryptex-type locked items where they have to figure out the clues to the combination, which they find in various ways. For example, one clue is a series of letters in a circle pattern with one letter highlighted and the number "7" in the middle of the circle. With no other help, they have to figure out that they start with the highlighted letter then move clockwise every seven letters to get their next clue. The clues and challenges get more elaborate as they go. In the end, there's a "pirate's treasure" type box where they need four special keys to open it (since there's four of them). I built the box and locking mechanisms myself such that the keys have have to be turned in the right order. Inside, there'll be a cache of US Presidential dollar coins (look like gold to a kid). The quests will take them at least a year or two before the 'big' payoff, but they'll get smaller things along the way, too.
I want to incorporate some technology into this and not just make it a geocaching-type physical adventure for the kids... and I want it to be educational, too. So, what I want to do is have a series of questions they have to answer to get bits and pieces of the next clue, using the computer. I thought Access would be a great place to start. So, for example, on a form I'd like to have the question showing and a control for them to enter the answer, plus a Submit button. If they answer correctly, that question disappears and the next question comes up. If they answer incorrectly, the question disappears and they get a "start again" message, and it cycles them back to the first question... as sort of a penalty for a wrong answer. Then, every fifth question they answer correctly (or so), they get a text control that appears to give them a piece of the next clue. Each questions will require they do some research... "Who was the third President of the United States?" "What country in Europe has the biggest economy?" What is the best MS Access forum website?" and the like.
So, I need some help on the code for the form Submit button to check the answer, then perform the correct action. I don't know how to check whether the answer is correct or not... if the answer equals... what? Plus, can I use the same controls on the form for subsequent questions and clue appearances, or am I going to have a bunch of visible/invisible controls which have their properties changed based on the Submit button On Click code?
Plus, is it possible to make it so that if they close the database and reopen it, it brings them back to where they were at the close? In other words, let's say they answer question 21 correctly, are looking at question 22 when grandma calls them to dinner. When they reopen the database, they're back at 22. But, if they answered 21 wrong, it kicks them back to number 1... then they go away and come back, it reopens at 1. I have NO idea how to do that.
Thanks so much for any help. Hopefully, I can put something together that they'll enjoy.
Here's the backstory: I'm in the process of putting together a series of clues, physical challenges and locked 'treasure boxes' and the like as a series of 'quests' for my grandkids (aged 10 and under). I have cryptex-type locked items where they have to figure out the clues to the combination, which they find in various ways. For example, one clue is a series of letters in a circle pattern with one letter highlighted and the number "7" in the middle of the circle. With no other help, they have to figure out that they start with the highlighted letter then move clockwise every seven letters to get their next clue. The clues and challenges get more elaborate as they go. In the end, there's a "pirate's treasure" type box where they need four special keys to open it (since there's four of them). I built the box and locking mechanisms myself such that the keys have have to be turned in the right order. Inside, there'll be a cache of US Presidential dollar coins (look like gold to a kid). The quests will take them at least a year or two before the 'big' payoff, but they'll get smaller things along the way, too.
I want to incorporate some technology into this and not just make it a geocaching-type physical adventure for the kids... and I want it to be educational, too. So, what I want to do is have a series of questions they have to answer to get bits and pieces of the next clue, using the computer. I thought Access would be a great place to start. So, for example, on a form I'd like to have the question showing and a control for them to enter the answer, plus a Submit button. If they answer correctly, that question disappears and the next question comes up. If they answer incorrectly, the question disappears and they get a "start again" message, and it cycles them back to the first question... as sort of a penalty for a wrong answer. Then, every fifth question they answer correctly (or so), they get a text control that appears to give them a piece of the next clue. Each questions will require they do some research... "Who was the third President of the United States?" "What country in Europe has the biggest economy?" What is the best MS Access forum website?" and the like.
So, I need some help on the code for the form Submit button to check the answer, then perform the correct action. I don't know how to check whether the answer is correct or not... if the answer equals... what? Plus, can I use the same controls on the form for subsequent questions and clue appearances, or am I going to have a bunch of visible/invisible controls which have their properties changed based on the Submit button On Click code?
Plus, is it possible to make it so that if they close the database and reopen it, it brings them back to where they were at the close? In other words, let's say they answer question 21 correctly, are looking at question 22 when grandma calls them to dinner. When they reopen the database, they're back at 22. But, if they answered 21 wrong, it kicks them back to number 1... then they go away and come back, it reopens at 1. I have NO idea how to do that.
Thanks so much for any help. Hopefully, I can put something together that they'll enjoy.
