Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > Access-L Developer's Libraries > Brightup, Earl
  New Posts New Posts RSS Feed - Increment Alpha Field.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

Increment Alpha Field.mdb

 Post Reply Post Reply
Author
Message Reverse Sort Order
Earl Brightup View Drop Down
Contributor
Contributor


Joined: 24 Jun 2008
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote Earl Brightup Quote  Post ReplyReply Direct Link To This Post Topic: Increment Alpha Field.mdb
    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: uploads/6/IncrementAlphaField.zip
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

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.