Access Expert 10 Lesson 1 - Microsoft Access Expert 10


	Back to Access Expert 10 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Access Expert 10 Lesson 1

Kenneth Wykoff

2 years ago

Good Evening! I'm sorry for bothering everyone yet again today but I'm at a loss. The first thing is about the PaidOrNot Selection. I typed the formula into the ControlSource as instructed per the video. But after I went into the design area and removed the IsPaid button, I replaced it with the PaidorNot field button and then tried to get it to work even after placing the macro in the Print Order Button for refresh record. The first record worked for Paid checked and unchecked and then the second order only worked on Paid and not Unpaid. I will upload a copy of the two formulas used for the first and second issues.

Second was trying to enter the formula into the Query for the Quotation and Invoice. I would not accept the formula and I'm pretty sure I entered it in correctly. If you can look at it and tell me what may be wrong I would appreciate it. Thanks again, Ken

	Kenneth Wykoff OP @Reply 2 years ago

	Kenneth Wykoff OP @Reply 2 years ago

	Kenneth Wykoff OP @Reply 2 years ago
Error is what I get from the Quotation or Invoice and the formulas I have used for both and placed into the control source are next

	Sami Shamma @Reply 2 years ago
you have a spelling error. It is IIF not IFF

	Kevin Robertson @Reply 2 years ago
In QuotationOrInvoice you have IFF instead of IIF.

	Kevin Robertson @Reply 2 years ago
Beat me to it Sami LOL

	Richard Rost @Reply 2 years ago
I used to make that mistake a lot when I started out. That's why in my videos now I say "iiiiiiiiiiiif not iffffffff."

	Sami Shamma @Reply 2 years ago
Kevin, I learned from the Masters.

	David Burns @Reply 2 years ago
LOL I have to watch for this as IFF is regularly used in maths to mean "if and only if".

Kenneth Wykoff OP @Reply

2 years ago

Again thanks gentlemen! I finally got it to work after I changed that and deleted on parenthesis that was placed in the formula and then it was accepted. Apparently the need to have a parenthesis after IsQuotation and bracket was not needed. So now I should be able to continue learning.

Just one last question on this First problem with the PaidOrNot part. I have everything correct I believe with the formula and have it posted in the control source and the refresh macro in place. It will not refresh always so not sure what is going on there still. It will refresh one order at a time but then I need to shut it all down to start another. And the second order, one will refresh for paid and the next time when I remove the check it still will say Paid.

	Kenneth Wykoff OP @Reply 2 years ago

	Kenneth Wykoff OP @Reply 2 years ago
Just when I thought I had it right, nope! Just so you know, I even opened the database download from the lesson and copied and pasted both of those formulas into the areas I was supposed to and it did not work still. Newest error message is attached. What is frustration is that the database download from online works.

	Kenneth Wykoff OP @Reply 2 years ago
OK PARTY TIME! I finally have this entire thing working after many trials and errors. I managed to watch the video a couple more times to beat it into my old brain. Did some refresh things and also ran an error check on it all. Whatever it all was, is now working so on to the next lesson, and again thank you all for the help you gave me.

	David Burns @Reply 2 years ago
Congrats on getting there, Kenneth

	Richard Rost @Reply 2 years ago
Congrats. An unexpected Enter Parameter Value prompt is usually from something being spelled wrong.

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

Next Unseen

New Feature: Comment Live View