Form_CustomSeriesByDefaultProperty |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
Posted: 02 Jul 2009 at 6:05am |
Form_CustomSeriesByDefaultProperty 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: 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: Version: Access 2000 file format. Download >>: uploads/37/Form_CustomSeriesByDefaultProperty.zip
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |