Generate serial number

Question

0.00/5 (No votes)

See more:

There is table with information about cars and its owners and some other documents, all this information will be writen on the special list (one row for one car and its owner), I need a unique serial number for each row in the table. Two letters and 6 numbers is a standart for this documents. Valid is a separate generator for letters and numbers, in diferent fields. Code should be such that it could be written to a button in MS Access, it is desirable VBA :confused:

Posted 28-Nov-10 6:02am

Olkoua

Updated 28-Nov-10 9:32am

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mohammed Husain Osman · Answer 1 · 2010-11-28T06:34:00

well , i access i can't help
but if you want some code in c# that can help you or may bring close the solution to you that is it :

private static string GenerateData(int lettersCount, int numsCount)
       {
           string str = string.Empty;
           Random ran = new Random();
           for (int i = 0; i < lettersCount; i++)
           {
               str += ((char)ran.Next(65, 91)).ToString();
           }
           for (int i = 0; i < numsCount; i++)
           {
               str += ran.Next(0, 9).ToString();
           }
           return str;
       }

i hope i can help more

Dr.Walt Fair, PE · Answer 2 · 2010-11-28T07:12:00

If you try to use a random generator, sooner or later you will get a duplicate. If you want to use a random sequence, then you'll need to check for dups each time.

I would use an incrementing system and save the last used in either a config file or Access table. When you need a new number, just increment the last one and save it back for next time. (That's basically how the AUTO INCREMENT works, but it only uses numbers, not letters.)

It's not clear whether the letters or numbers actually need to mean anything, but that's something you'll have to decide.

Generate serial number

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0