TrackNameChange.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
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 sequence. 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/TrackNameChange.zip |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |