Gents,
Hi, I have the following code:
Dim rs As Recordset
Set rs = CurrentDb.OpenRecordset(MySQL)
If rs.RecordCount > 0 Then
rs.MoveFirst
Do Until rs.EOF
If IsNull(rs!Email) Then
rs.MoveNext
My problem that sometimes the record of the Email is repeated on the second line, the system seemed to think as a different email. How can i tell the system that if it is the same skip to another.
Thanks
Hi, I have the following code:
Dim rs As Recordset
Set rs = CurrentDb.OpenRecordset(MySQL)
If rs.RecordCount > 0 Then
rs.MoveFirst
Do Until rs.EOF
If IsNull(rs!Email) Then
rs.MoveNext
My problem that sometimes the record of the Email is repeated on the second line, the system seemed to think as a different email. How can i tell the system that if it is the same skip to another.
Thanks