Incrementing Alphanumeric Fields

[Rod Caddy]

On 1/19/2012 1:13 PM, Bruce Easton wrote:
> I don't see anything wrong with the code in a perfect world (that
> agrees with it).  But because assigning a new number involves an
> indexed lookup, the results are subject to:
>
> 1. the data already on file (are their invalid values stored for field
> 1?), and
> 2. the health of the automatic index used for the lookup
>
> Also, since you say it will sometimes jump to U####, then could
> the user sometimes be holding down the U a little too long
> (when they have keyed U to go into update mode and this field
> 1 is the first field on the screen)?  I guess I am wondering if
> the field sometimes is populated correctly, but the user is
> unintentionally overwriting one or more characters with the
> same U that was being held to go into update mode.
>
> Bruce
>
>
>
>
snip

You know Bruce, as dumb as it may sound, I had not thought of the 
possibility that someone could be holding the U down too long but I can 
fix that.
Thanks
-- 

Pro-Set Systems Logo <www.pro-set.com>  Rod Caddy
   Pro-Set Systems
   rcaddy at pro-set.com
The information in this e-mail is confidential and may be privileged. If
   you are not the intended recipient, please destroy this e-mail and
   notify the sender immediately. You should not retain, copy, distribute
   or use this e-mail for any purpose, nor disclose any of its contents to
   any other person.