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 - Form_CustomSeriesByDefaultProperty
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)


 Post Reply Post Reply
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: Form_CustomSeriesByDefaultProperty
    Posted: 02 Jul 2009 at 6:05am

Updated On 28-Jul-2012  (Plain number series added)

Explanatory Notes

    This sample db demonstrates a novel approach involving generation of value sequence via a common function embedded as default value property of the bound control carrying such values.

    As the data entry progresses, the default value keeps incrementing as required, without having to undertake any special manipulation via form's current event. Moreover, it is not necessary to use even other form events like Dirty / Before or After Insert / Before or After Update etc.

    Two styles are covered:
    1 - Plain Number Series.
    2 - Alpha-Numeric Series (Number series with text prefix) 

    The prefix is selected via combo box on the main form. Whenever, a new prefix is selected, the newly displayed default value on the subform gets set 1 higher than the existing highest in alpha-numeric sequence pertaining to the selected prefix. If there is no existing entry with the given prefix, the default value gets set to prefix followed by 000001.

    Type of prefix can be selected via the option group as follows:
    (a) Prefix by combo box selection. 
    (b) Prefix as per current year (yyyy)
    (c) Prefix as per current year month (yyyymm)

Version: Access 2000 file format.

Reference: Nothing extra.


Back to Top
Sponsored Links

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.