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: 22 Oct 2017 at 10:22pm


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 -




Print Page | Close Window