Access enables you to create expressions without requiring that you be a programmer, although some familiarity with a programming ...
Problem: Started in a Focal Point post, the question is, how to validate Date (calendar) controls in a guided ad-hoc HTML page?
There have been so many problems with users not entering the date in mm/dd/yyyy, even when specifically stated on the screen.
Solution: Tom Flynn from Sun Gard Higher Education provided the following Jave Script, which helped resolving the issue, so many thanks to Tom!
It's tedious because entering dozens or hundreds of records is no one's idea of fun.For example, asking someone to type a customer name manually is both slow and prone to misspellings.However, suppose you already have a Customers table with a field to the current form using a drop-down list that contains all the customers.To add simple tests for the reasonableness of entries, add short expressions as a Validation Rule in the General page of Table Design view's Field Properties pane.If the entered data fails to conform to your validation rule, a message box informs the operator that a violation occurred.