Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - TrackNameChange.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)


 Post Reply Post Reply
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP

Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: TrackNameChange.mdb
    Posted: 06 Jul 2008 at 10:40pm
This sample db demonstrates tracking of name changes spread over different 
records. Basic data is contained in a table having three fields (one primary key - 
autonumber type, and two text fields named OldName & NewName respectively).

For each OldName, there is a NewName & vice versa. As an illustration, one typical 
set of records might be -
OLDNAME                   NEWNAME
CocaCola                     CocaColaClassic
CocaColaClassic          CherryCoke
CherryCoke                  CherryCokeClassic
CherryCokeClassic       DietCoke

The sample db enables correlation of any OldName with the last NewName in the 
sequence. Similarly, it correlates any NewName with the first OldName in the 

Data entry incorporates autocomplete feature for OldName field (filling in the closest 
match from the recently filled NewNames).
Versions - Access (In Access 2000 File Format)
References - ADO 2.1 
Download Access Version XP&2K: uploads/37/ 

Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.