MMcCarthy,
Sorry I haven't responded sooner.
Your coding works like a charm. I appreciate everyone's assistance.
Thanks!
Theodore70
Last Activity: Oct 24 '06, 09:01 PM
Joined: Oct 19 '06
Location:
-
The values of DMax are alphanumeric.
I am trying to delete duplicated (SMTP - email) since it is my only unique identifier available. It is a text field.
Thanks.
<What is the value in email field. As you are using DMax I assume it's a number or date. Can you confirm?
If it's a date, are you just trying to create a list of emails by the last date sent by deleting all other emails....Leave a comment:
-
Apologies. I wasn't not clear on my original post.
I would like to delete duplicate records (email field), but keep at least one record. I have revised the script based on the replies that I have recieved, but I am still not able to get the script to run correctly.
Any help is appreciated.
Thanks.Leave a comment:
-
Delete Duplicate records
I am trying to delete duplicate records in an access table using VB. Not a programmer here, but this was one of the codes that I found on the web. I made some modifications to it, but it still did not work for me.
...Code:Public Function DeleteDuplicate() Dim db As DAO.Database Dim qdf As QueryDef Dim strSQL As String Dim strEmail As String dteEmail = DMax("[Email]", "tbl_email")
No activity results to display
Leave a comment: