Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - AppendSequence.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

AppendSequence.mdb

 Post Reply Post Reply
Author
Message Reverse Sort Order
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: AppendSequence.mdb
    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/AppendSequence.zip

--

Email: adtejpal@gmail.com
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

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