I have a long established program that was running in Access 2010 with no problems. Now we have moved to Office 365 (which I think is Access 2019) and we have a new problem.
The code is 'NumRecs = rsLotBid.RecordCount'. And the word RecordCount comes up with an error, 'Compile error: Type mismatch'. Has RecordCount changed in Access 2019? Any suggestion of how to remove this error message? Presumably I can change NumRecs to be the same type as RecordCount, if I knew what type that is?
Robert
The code is 'NumRecs = rsLotBid.RecordCount'. And the word RecordCount comes up with an error, 'Compile error: Type mismatch'. Has RecordCount changed in Access 2019? Any suggestion of how to remove this error message? Presumably I can change NumRecs to be the same type as RecordCount, if I knew what type that is?
Robert