Corporate DeDuping Module in VB

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

Beceriler: Microsoft Access, Visual Basic

Daha fazlasını gör: programming module, programming in vba, programming in objective c, module programming, microsoft access programming, microsoft vba, in vba, find in vba, microsoft access vba, in process access, access vba program, vba production, table size access, microsoft access check, production access microsoft, vba programming access, access table size, access table size vba, objective visual basic, access production, basic characters, access table vba, access method, production module, objective microsoft visual

İşveren Hakkında:
( 9 değerlendirme ) West Freehold, United States

Proje NO: #4414842



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.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(6 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(468 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde80%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(40 Değerlendirme)

Greetings , kindly check PMB

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(14 Değerlendirme)

Hello! Let me propose you all my best of experience in VB and Microsoft Access! Thank you! Denis Smolentsev

in %bids___i_period_sub_35% gün içinde140%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(39 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde242%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)

Dear mam, I'm expert on access and vba, i'd like to help you. Beast Regards, NourElDeen

in %bids___i_period_sub_35% gün içinde45%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(19 Değerlendirme)

More than 10 years experience in VBA.

in %bids___i_period_sub_35% gün içinde77%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)

Hi We are Expert VBA/VB Programmers,We want to do it,Please see PMB

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde154%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

*********** Already DONE, please check the attached VBA module. Thanks *************

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(5 Değerlendirme)

Hello, I am interested to do this work. Thanks

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)

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.

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

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.

in %bids___i_period_sub_35% gün içinde60%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

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

in %bids___i_period_sub_35% gün içinde140%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

please check your pm

in %bids___i_period_sub_35% gün içinde140%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

Hi, I want to this software for you Thanks in advance.

in %bids___i_period_sub_35% gün içinde49%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

VB and VBA expert for over a decade

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hi, I have over 6+ years of VBA experience. I have an initial code sample ready.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)