Autonumber generation in VB

[Bidipta Samder]

Sir/madam,
I am doing a project on admission procedure using VB6. I am facing certain problems regarding that.....

1) Problem that i am facing is to generate alphanumeric auto numbers in two columns(Rollno. & Reg no.) in same table, in access.

[Alex ERS]

You can generate numbers in a VB method and then pass them to DB via INSERT or UPDATE SQL query.

The simplest way is to create a string constant or an array of chars which contains allowed symbols (0-9, A-Z for example), and to take one by one element by random indexes.