How to find out that a field in Ms Access Database contains two or more same records? I tried using
"If RS.Recordcount > 1" but it does not work out.
I don't have a primary key defined in my database.
Any help will be appreciated.
:p kInjal :p
Printable View
How to find out that a field in Ms Access Database contains two or more same records? I tried using
"If RS.Recordcount > 1" but it does not work out.
I don't have a primary key defined in my database.
Any help will be appreciated.
:p kInjal :p
dim Recordcounter as string
on error resume next 'incase there is no records
Database.Recordset.Movelast
Database.Recordset.Movefirst
recordcounter = database.recordset.recordcount
this will give you the recordcount that you want...
Hope this helps