Print Page | Close Window


Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
Printed Date: 16 Jul 2018 at 10:43am

Topic: AppendSequence.mdb
Posted By: A.D. Tejpal
Subject: AppendSequence.mdb
Date Posted: 10 Jul 2008 at 1:54am
This sample demonstrates appending of sequential values in continuation to
those existing in the target table (Reference ADO 2.1).

Following situations are covered (separately for batch mode as well as data entry mode-
        (a) Straight primary sequence of numbers.
        (b) Parallel sequences of strings - datewise.
        (c) Parallel sequences of strings - yearwise.
        (d) Parallel sequences of strings - yearmonthwise
        In addition, data entry mode is demonstrated for
                  (i) Alphanumeric sequential values (multiple parallel series)
                  (ii) Linked sub-sequential values
                  (iii Formatted sequential numbers

In Batch Mode, the above objectives are achieved through append queries 
(marked by faster execution as compared to stepping through recordset loops).

Caution - The append queries make use of global variables through user 
defined functions. 
While such an approach works nicely for single pass action queries (as in current 
case), it is not recommended for display oriented queries (e.g. select query etc.) as 
the calculated values are highly volatile (mere navigation through the column will 
keep disturbing the values).

Download Access 2K & XP: - uploads/37/


Email: -

Print Page | Close Window