Increment Alpha Field.mdb |
Post Reply |
Author | |
Earl Brightup
Contributor Joined: 24 Jun 2008 Status: Offline Points: 3 |
Post Options
Thanks(0)
Posted: 24 Jun 2008 at 10:33pm |
This code increments by one (1) the rightmost character (of an alphanumeric string) which can be incremented. Non-alphanumeric characters are filtered out prior to incrementing. 0-9 are incremented only within this range. If the rightmost character cannot be incremented, the character next left is incremented if possible, attempts continuing all the way to the leftmost character. If a character other than the rightmost is incremented, all the characters to the right of the incremented character are reset to the first character of their respective ranges. If no character can be incremented, an error message is issued. Download Access 2000: uploads/6/IncrementAlphaField.zip |
|
Email: earlreb@charter.net
|
|
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 |