Search results

I have no clue on coding or queries.. Do you recommend any sites or know of anything that can help? :/

I just wanted to make sure is all, if something can go wrong, it will. Don't worry. So how should I go from here?

Oh, is there a way to check they're connected? And eh, I could but that wasn't tooo bad. :D

Very well. What should I go about doing next?

Thank you for your video, that explained it well, aha. (Probably gonna sound creepy, but your voice is really nice to listen to. :D) Okay. The answers form is now on the main questions form. How do I do from there? I can't put questionsID within tblAnswers as a Autonumber, it says I can only...

Ah.. There's autonumber or number. It's fieldsize allows me to choose long integer. It only allows one autonumber field per table however, so I've had to put questionID as number within tbl_Questions. Is that okay? Or..? The answers form, is that showing all fields? I created both forms using...

The answers form, is that showing all fields? I created both forms using form wizard, basing it off the tables. What do you mean datasheet view? I can put the original answers table in datasheet view, but not the form. The tbl_answers based form had only viewing options of 'form','layout' and...

Thank you. And when you say 'Long', are you reffering to Long Text, regarding AnswerID and QuestionID's datatypes? In tblQuestion, QuestionID was automatically set to autonumber, hence the ID. The same is for my AnswerID within tblAnswer. Do all of these need to be set to autonumber or long...

Boolean? That isn't an option here. I'm using Access 2016, if that helps. I shall start working on everything else now.

Did you want to know anything else? ^^

There should never be more than 5 questions per quiz. :)

I have the first quiz's questions and answers. What does your role focus on during work? A. Customer Service. (Correct) B. High Profits C. Efficiency. D. Productivity. What does we aim to provide? A. A service to help children, teens and adults to borrow books and access computers that...

Questions will be a question that only has one correct answer. There will be four possible answers for the user to choose from, the method of choosing would be clicking an ‘option button’ with the label describing the answer. One will be correct, three incorrect. I did it this way to attempt to...

There will be no need, it will only need to be stored temporarily. So that's no issue. :)

My project is about a training program. There's about 8 quizzes. I've made forms which they choose which quiz through,and currently have s blank form for each quiz. (So 8 blank forms) I was just going to take the advice you gave for one quiz and replicate it 7 more times.

That's it, yes. You grasped the concept perfectly. Calculations made and then appropriate macros bringing users to the correct forms depending on their score. The only storage in any sense round be via a table that I wish to automatically update once the user has completed a quiz...

Yes. tbl_Quiz QuestionID (Auto-number, PK) Question Answer UserAnswer I was told to have a table that it can store them, so I made that above. I don't know if that's how it should work or what, but yes, I do. Well, only store until the end of the quiz, then it would calculate how many the...

How do I make the form display questions individually from a table? And how do I get the table to record the answers the user gives?

Guys, please help me here.

Hi all, Firstly, I know that there are other options that may be slightly easier, however the quiz is only part of my access project and so I wish to keep it IN ACCESS, so don't worry about suggesting alternatives. Secondly, I put this in forms as I want the end quiz to be in a form for the...