axfernand
asked on
Auto Increment Text Field
Hello,
I have a 2 character text field that I need to increment automatically in a table via VBA. For example, I have a record with the pseudo key AA that I need to create a new record for under pseudo key AB. I have thousands of records that I need to do this for. Here are some examples of the keys I'm working with: AA, CB, AZ, ZA, PQ, et...the records that are created look at the alphabet for the second digit and adds the next consecutive letter. How would I be able to do this via VBA?
Thank you.
I have a 2 character text field that I need to increment automatically in a table via VBA. For example, I have a record with the pseudo key AA that I need to create a new record for under pseudo key AB. I have thousands of records that I need to do this for. Here are some examples of the keys I'm working with: AA, CB, AZ, ZA, PQ, et...the records that are created look at the alphabet for the second digit and adds the next consecutive letter. How would I be able to do this via VBA?
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Guys,
Haven't had a chance to apply your code but will do next week. Thanks for the responses.
Haven't had a chance to apply your code but will do next week. Thanks for the responses.
test this function,
Open in new window
?getNextValue("AA")AB