Devam Ediyor

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ün: 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

Seçilen:

MarlinSoftware

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 40$ USD
(6 Değerlendirme)
3.8

20 freelancer bu iş için ortalamada 80$ teklif veriyor

Prashantskin

[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 3 gün içinde100$ USD
(468 Değerlendirme)
6.9
amcsummers

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 fazlası

in 2 gün içinde80$ USD
(40 Değerlendirme)
5.1
AmirAly

Greetings , kindly check PMB

1 gün içinde 50$ USD
(14 Değerlendirme)
4.7
DenisSmolentsev

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

in 10 gün içinde140$ USD
(39 Değerlendirme)
4.6
expertcoder1vw

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 fazlası

in 5 gün içinde242$ USD
(10 Değerlendirme)
4.3
NourElDeen

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

in 2 gün içinde45$ USD
(19 Değerlendirme)
4.1
adim

More than 10 years experience in VBA.

in 3 gün içinde77$ USD
(10 Değerlendirme)
4.1
srdas2012

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

in 7 gün içinde200$ USD
(10 Değerlendirme)
3.3
parsermonster

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 fazlası

in 3 gün içinde154$ USD
(3 Değerlendirme)
3.2
Solver86

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

1 gün içinde 40$ USD
(5 Değerlendirme)
3.1
sumon355

Hello, I am interested to do this work. Thanks

in 2 gün içinde35$ USD
(12 Değerlendirme)
3.1
soikaushik2013

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 3 gün içinde50$ USD
(2 Değerlendirme)
2.9
justindonlon

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 5 gün içinde60$ USD
(1 Değerlendirme)
1.1
Pharoa

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 fazlası

in 3 gün içinde140$ USD
(0 Değerlendirme)
3.1
sirmhb

please check your pm

in 7 gün içinde140$ USD
(0 Değerlendirme)
0.0
biljanakazandzic

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 70$ USD
(0 Değerlendirme)
0.0
sbengul

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

in 3 gün içinde49$ USD
(0 Değerlendirme)
0.0
animedreamer

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 55$ USD
(0 Değerlendirme)
0.0
paris2785

VB and VBA expert for over a decade

in 3 gün içinde30$ USD
(0 Değerlendirme)
0.0
lphedman

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

1 gün içinde 40$ USD
(0 Değerlendirme)
0.0