Base-34 class or alternetives

[is49460]

Hello,

I need to have a base-34 (or base-36) numeric system for one of the fields in my database. The field itself can be only 2 characters long (and that's the reason for the base-34 type to get as many unique values as possible). After doing a little research I couldn't really find anything about base-34 coded in VBA. So, I thought to ask if anyone has any advice or references before I start coding from scratch (not having overload operators in VBA will not make it pretty....) Thanks for suggestions.

[is49460]

Rather than creating an entire class with all the operators, the latest idea of my own was to create two functions: DecTo34 and my34ToDec. Use those functions to convert stored value to decemal to make calculations and then convert the value back to base-34 once the number is ready to be stored. Any comments?

[TheShabz]

I did a google search for "decimal to alphanumeric" (base-36), and found this http://social.msdn.microsoft.com/For...a-21c1f0b9762b

[is49460]

I did a google search for "decimal to alphanumeric" (base-36), and found this http://social.msdn.microsoft.com/For...a-21c1f0b9762b

Thanks for the reference. I'll probably end up doing just that adding the second function to convert back to decimal. Thanks again!