MS Access VBA Code

Cancelled Posted Apr 1, 2006 Paid on delivery
Cancelled Paid on delivery

**RAPID TURNAROUND REQUIRED! WE NEED TO GO LIVE WITH THIS MS ACCESS ROUTINE TODAY!**

We are processing mailing lists from multiple different sources using Microsoft Access. As a part of this process, we must match records together that are from the same business location. We match records by creating a MatchKey. For example, for the following record:

ABC Company

123 Main Street

Anytown, VA, 22111

We may create a MatchKey that combines the zip code and company name (22111ABC). Because of the poor quality of the data, we are having to create multiple MatchKeys. So, for example, our first MatchKey for the above record may be 22111ABC, and our second may be 221123MAIN (combining zip code and street address).

Ultimately, we may have 2, 3 or more matchkeys. We have no problem creating the matchkeys ourselves. But we need an algorithm to bring ALL the matchkeys together to create a single "Master Key."

The attached .mdb file contains an example of what our table would look like before and after the "Master Key" process runs. In addition, it includes a subroutine (in Module1) that contains specific requirements for the subroutine we need developed.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) An MS Access module, delivered as part of an MDB database in ready-to-run condition.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

MS Access XP

Win XP Pro

Engineering Microsoft Access MySQL PHP Software Architecture Software Testing Visual Basic for Apps

Project ID: #3398516

About the project

7 proposals Remote project Active Apr 5, 2006

7 freelancers are bidding on average $98 for this job

pShankar2

See private message.

$85 USD in 1 day
(410 Reviews)
7.1
branislavm

See private message.

$102 USD in 1 day
(253 Reviews)
6.4
siluvw

See private message.

$72.25 USD in 1 day
(108 Reviews)
4.7
dyton3d

See private message.

$85 USD in 1 day
(14 Reviews)
4.0
meenavenkatesh

See private message.

$127.5 USD in 1 day
(8 Reviews)
3.6
Lantis

See private message.

$140.25 USD in 1 day
(4 Reviews)
1.5
angellore

See private message.

$76.5 USD in 1 day
(0 Reviews)
0.0