Form_CustomSeriesByDefaultProperty

   Form_CustomSeriesByDefaultProperty
Explanatory Notes
    This sample db demonstrates a novel approach involving generation of alphanumeric sequence as per specified prefix, 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. 

    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.
Download >>:  uploads/37/Form_CustomSeriesByDefaultProperty.zip

Author	Message / View First Unread Post Share Topic Printable Version Delicious Digg Facebook Furl Google MySpace Newsvine reddit StumbleUpon Translate Twitter Windows Live Yahoo Bookmarks Topic Search Topic Options Post Reply Create New Topic
A.D. Tejpal Members Profile Send Private Message Find Members Posts Add to Buddy List Microsoft MVP Joined: 01 Jul 2008 Online Status: Offline Posts: 154	Post Options Post Reply Quote A.D. Tejpal Report Post Quote Reply Topic: Form_CustomSeriesByDefaultProperty Posted: 02 Jul 2009 at 2:05pm
	Form_CustomSeriesByDefaultProperty Explanatory Notes This sample db demonstrates a novel approach involving generation of alphanumeric sequence as per specified prefix, 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. 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. Download >>: uploads/37/Form_CustomSeriesByDefaultProperty.zip
	-- Email: adtp@airtelmail.in