Search:

http://www.freevbcode.com/ShowCode.asp?ID=5440 ???


Function IncrementString(ByVal strString As String) As String
'
' Increments a string counter
' e.g. "a" -> "b"
' "az" -> "ba"
' ...

Sure. Each letter has a numerical value, so you'd use the lowest A or a, to the upper z or Z.

You'd have to write a module to generate the value by hand. Pass the current value, and add one. ...

Only if you code it by hand..

Well, you should be using a GUID to identify each key. Then, you can assign/change each generated number when you want, even if editing is not allowed!

Link tables via their GUID, and you'll have...