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: http://www.rogersaccesslibrary.com/forum/uploads/37/AppendSequence.zip - uploads/37/AppendSequence.zip
------------- --
Email: mailto:adtejpal@gmail.com - adtejpal@gmail.com
|