How can it be done, such that the calculated value can't be zero or negative, eg 2-3=-1 how can I set the validation such that the result it must not be negative, rather it will cancel?
Very good question. Another one of my members asked the same thing a few days ago. I'll be making a video on this soon. There are two ways to do it. A table-level validation rule or a BeforeUpdate event.
For me there is total fees and pending fees (pending fees should not exceed total fees) so wht ever fees tht I will add in table should be less than total fees
You mean 10 digits? I would use an Input Mask instead. 0=MUST enter, 9=CAN enter. So if you want a max of 10 digits, set it to 9999999999. If you want 10 and exactly 10 digits, make it 0000000000. See: th-cam.com/video/G7TQIGcbi_A/w-d-xo.html
Very clear and effective explanation, ty!
You're very welcome!
Super Helpful, Deserves a like!!!
Glad to hear that!
Super explaining
Thank you
GOOD ..... HOW TO USE DEFAULT TEXT IN MS ACCESS
Default Value: 599cd.com/Default
How do i do this--
"The amount should be minimum 100 and maximum 500"
Should i use between???
Sure
How can it be done, such that the calculated value can't be zero or negative, eg 2-3=-1 how can I set the validation such that the result it must not be negative, rather it will cancel?
Very good question. Another one of my members asked the same thing a few days ago. I'll be making a video on this soon. There are two ways to do it. A table-level validation rule or a BeforeUpdate event.
Very good lesson ☺
Thank you! 😃
I know this is late but how do I make a validation rule that only accepts answers: beginner, intermediate and advanced
Use a combo box
Hi, how to make a validation rule if you set the digits 15 or 18 or 20 strictly (barcode), I have tried >=100000000000000 And
Use a Double
For me there is total fees and pending fees (pending fees should not exceed total fees) so wht ever fees tht I will add in table should be less than total fees
That would make a good validation rule.
#01/01/2009# what is this rule doing?
Saying you want to see records from 1/1/09
Tysm! it was really helpful 🙃
My pleasure.
thank you very much
Welcome
how do i create a rule where the user can only input 10 numbers
You mean 10 digits? I would use an Input Mask instead. 0=MUST enter, 9=CAN enter. So if you want a max of 10 digits, set it to 9999999999. If you want 10 and exactly 10 digits, make it 0000000000. See: th-cam.com/video/G7TQIGcbi_A/w-d-xo.html
@@599CD thank you
Good man thank you helped me out in a pickle! Mind blank Tuesdays lol haha someone get me a coffee : D
Glad I could help!
Thank youuu
Welcomeee
thanks sir
Most welcome
360p in 2019?
Yeah that video is even older - probably 2013. I uploaded it in 2019. All my new stuff is in 720p which is fine for screen tutorials.
life
Indeed!
NICE
Thanks
thank you so much
You're welcome!