Search results

Thanks David, Im still a little unsure, I've created a new module and saved the public function inside it. I am unsure exactly what to do in terms of using the On Current Event to call the function as when I include the code you have given: If RetirementDue(Me.TxtDOB,65,7) = True Then...

This may sound really silly, but where shall I include this script? Shall I create a text box and place it within it? Sorry I'm not the best with databases.

Baiscally the age of the employee should be 64 and 5 months before they turn 65 when a message should display, but as I have the date of birth in a date format i.e. dd/mm/yyyy, I am not to sure how this will work.

Hi, I am trying to create a prompt to slert the user that an employee is due to retire. The age in which it should say this is 65 years of age. As the age of the employee is currently within a Date of Birth format, I am not to sure of how to get this done. The prompt should show 7 months...