Tejpal, A.D. - TrackMissingAndDuplicates.mdb

Print Page | Close Window

TrackMissingAndDuplicates.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=29
Printed Date: 16 Apr 2024 at 4:17am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com

Topic: TrackMissingAndDuplicates.mdb

Posted By: A.D. Tejpal
Subject: TrackMissingAndDuplicates.mdb
Date Posted: 06 Jul 2008 at 10:44pm

This sample demonstrates monitoring of sequential values so as to keep track 
of missing as well as duplicate values.

The status form displays the following information (side by side) -
(a) Overall Position as existing. (Records where next required sequential value
is missing are highlighted. In addition, records carrying duplicate values are also 
highlighted in different color).
(b) Gist of missing sequential values.
(c) Gist of duplicate sequential values.
Update:
The scope has now been expanded so as to cover -
    (a) String values with formatted numeric suffix.
    (b) String values with un-formatted numeric suffix.
    (c) Pure dates.
    (d) Pure numbers.

Download Access XP & 2K: http://www.rogersaccesslibrary.com/forum/uploads/37/TrackMissingAndDuplicates.zip -