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: 26 Jan 2021 at 7:21am
Software Version: Web Wiz Forums 12.03 -

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

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