L
Leonard Priestley
I have put together a small database for a friend who is not very
computer-literate, and needs some help to ensure he gets it right.
Therefore I have supplied a mask in several boxes where he is entering time
values.
He still seems to have a problem, in that he tends to forget that if he
wants to enter 9 am, he needs to put "09:00". He tends to enter the initial
nine, followed by two zeroes, and of course he gets an error message, but it
doesn't really put matters in language plain enough for him.
I would like the database to detect his error and pre-empt the Access
standard message with something simpler, like "Put a zero before the time
you're entering". I imagine it involves supplying a validation rule, or
perhaps using the Before Update event, but I can't figure how to do it. I'd
appreciate any help people can give.
Leonard Priestley
computer-literate, and needs some help to ensure he gets it right.
Therefore I have supplied a mask in several boxes where he is entering time
values.
He still seems to have a problem, in that he tends to forget that if he
wants to enter 9 am, he needs to put "09:00". He tends to enter the initial
nine, followed by two zeroes, and of course he gets an error message, but it
doesn't really put matters in language plain enough for him.
I would like the database to detect his error and pre-empt the Access
standard message with something simpler, like "Put a zero before the time
you're entering". I imagine it involves supplying a validation rule, or
perhaps using the Before Update event, but I can't figure how to do it. I'd
appreciate any help people can give.
Leonard Priestley