We have a module that reads records from 1 table and adds them to others. The data type on a field changed from numeric to text and we now get a data type mismatch error. I've confirmed all the tables are defined correctly. There must be an issue with the syntax of the code. The If statement below is where it fails
Do Until .EOF
Set rstApplicant = db.OpenRecordset("Charity Applicant", dbOpenDynaset)
If DCount("*", "Charity Applicant", "[MRN] = " & ![MRN]) = 0 Then...
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.