Last post May 05, 2009 03:41 AM by HaymanLTD
May 05, 2009 03:41 AM|HaymanLTD|LINK
Hi, I am making a database for a small business that allows rental of tractors using Microsoft Access 2007.
I need help with a couple of codes for queries.
The first one is a code that restricts the user to make an applicant under the age of 18 with their date of birth from the Now() command. I have the date difference of years but I can't get it to show a validation message notifying the data entry applicant
the person must be over 18 years of age.
The second code is one that if is not returned by the [due_date] it is then checked in a checkbox if so, is their an easier way to do this? if going from the checkbox how can I make the query search for checkboxes that are ticked? I have tried going from
vb.net knowledge be adding: if (Checkbox_name) = True but this showed up as a 0 or -1. Unless this is the correct way, how can I make it say Yes if it is overdue or with the loan_date and due_dates that I have to automatically detect if it is overdue.
Greatly appreciate any help