Search results

I have a form with fields last name, first name, is Adjuster active (check for yes) and adjuster email. I have the before update to not allow the record to be submitted if there are blanks but I am unsure how to write the VBA to give the error messages to tell the user to fill in the blank...

Perfect thanks for the help! works great!

I have the following statement: SELECT States.st, Licenses.[Expiration Date], IIf([Expiration Date]<Date()," Not Compliant","Compliant") AS Compliant FROM States INNER JOIN Licenses ON States.st_ID = Licenses.st_ID; What I need to do now is count the number of compliant returns with-in each...

Hi i am new