Corporate Deduping Module
April 9, 2013
1) Objective: The objective of this module is to determine if the records marked Dup in the Verify column in tblCorp are actually duplicates.
2) Method: The method we want to use to determine is the following
a. The program will go to the first record with a Dup in the Verify Column.
b. The program will then take the first 7 characters of the record in the CoMstrName and check if the 7 characters are located in another record.
i. If the program finds a record with the same 7 characters in the same order then it will leave the Dup column unchanged.
ii. If the Program does not find a record with the same 7 characters in the same order then the program will clear the Dup characters from the Verify Column for that record.
c. This process will be completed for each of the records in the table.
3) The programming should be done in VBA and be incorporated as a Module in the Access Program.
4) It should also be easy for the user to change the number 7 to select fewer or more characters.
5) The size of tblCorp in production will exceed 50K Records
Hi, thank you for your detailed specification. I have over 12 years experience building complex database systems in MS Access and could complete this project for you within an hour.
20 freelancers are bidding on average $80 for this job
[url removed, login to view] I have gone through your project requirements. I have also gone through your db. I will do the job within 1 day. Please see PMB for demo Thanks for your time Regards Prashant
Using VBA would work well for this project. I could design it so a Input box will appear asking you how many characters you would like to evaluate. I am thinking this would probably take 4-5 hours. For the past 15 Daha Fazla
Hello! Let me propose you all my best of experience in VB and Microsoft Access! Thank you! Denis Smolentsev
I'm an expert MS-Access / VBA developer and have experience developing de-duping code. I've read your requirements and understood them. I can do this job for you starting today, and can deliver within 5 days (maybe Daha Fazla
Dear mam, I'm expert on access and vba, i'd like to help you. Beast Regards, NourElDeen
Hi We are Expert VBA/VB Programmers,We want to do it,Please see PMB
Dear Project Manager, I am a veteran of Access Query / Search and VBA methods. I built the first Latent fingerprint database for the Philadelphia Police Department. Lots of opportunities to validate duplicate record Daha Fazla
Hello, I am interested to work in this project. I have 9 yrs of experience in this field. Let's start the job immediately. Thank you.
Hi There, MS Access with VBA is my speciality, I'd like to work on this project! I've worked on many data integrity type projects which include this type of work.
Thanks for the opportunity to bid on your project. I submit my bid having read your tender advert and understanding requirements of same! If awarded, I will bring over 19 years of technical programming experience Daha Fazla
I can do it very easy in one day , also I can do it like procedure from MS Access so it would be easy to use it in your original data base.
Hi, I want to this software for you Thanks in advance.
Hello. I have already created a proof-of-concept design for your problem and believe I could deliver a solution within 2 hours, perhaps longer if tweaks are required. Please let me know if you have any questions.