Access Developer 3 Lesson 3 - Microsoft Access Developer 3


	Back to Access Developer 3 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Access Developer 3 Lesson 3

Ken Wykoff

4 months ago

I am a bit stumped. I got the coding correct, I believe, per the video; however, when I run it to get the question and answers correct or wrong, it all comes up correct. I must be missing something, but I even checked the handbook, and it looks the same as on the video. Any ideas?

	Ken Wykoff OP @Reply 4 months ago

	Kevin Robertson @Reply 4 months ago
The first line of your if statement is wrong. Change to the following: `If Answer = Q1 + Q2 Then`

	Paul Kiener @Reply 4 months ago
Also the line beginning with "Answer", you have "Q!" instead of "Q1"

	Ken Wykoff OP @Reply 4 months ago
Paul Thanks, Paul, I just found that finally, before logging back on here. After changing it, it still didn't work.

	Ken Wykoff OP @Reply 4 months ago
Kevin Thanks Kevin, I will try that but look at this screenshot from the video lesson too please. It worked fine for Richard, just not me. Let me try your way too.

	Ken Wykoff OP @Reply 4 months ago

	Ken Wykoff OP @Reply 4 months ago
Guys, I also forgot to mention the debug yellow line goes through the line: Answer = InputBox....

	Ken Wykoff OP @Reply 4 months ago
Kevin, your way worked for me and thank you.

	Donald Lader @Reply 4 months ago
Ken, Richard has If Q1 + Q2 = Answer and you have If Q1 + Q2 + Answer. Kevin addressed this and this is why it works. The original code is fine.

	Ken Wykoff OP @Reply 4 months ago
Donald Donald, great eyes and thanks. I looked it over several times and never saw that till you mentioned it. Thanks.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer 3.

Next Unseen

New Feature: Comment Live View