Print Page | Close Window

Increment Alpha Field.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Brightup, Earl
Forum Description: Earl Brightup's Samples
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=21
Printed Date: 28 Mar 2024 at 2:56pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: Increment Alpha Field.mdb
Posted By: Earl Brightup
Subject: Increment Alpha Field.mdb
Date 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.
A-Z are incremented only within this range.
a-z 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: http://www.rogersaccesslibrary.com/forum/uploads/6/IncrementAlphaField.zip - uploads/6/IncrementAlphaField.zip

-------------
Email: mailto:earlreb@charter.net - earlreb@charter.net




Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net