Auto Increment Text Field
Posted on 2014-04-08
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?