Is it possible to identify duplicate records using vb6?

Hi, is is it possible to write vba code to identify duplicate records, which help with deduplication in ms access? If so, would you know or any sample code I could use to do this?



Thanks


:friends:

To find duplicate entries in single field use below query

Code:

---


SELECT fldname FROM tblname GROUP BY fldname HAVING COUNT(fldname)>1

---

Have you tried the duplicates query wizard?