Sequential Numbering Auto "Bar-Code" (1 Viewer)

vdanelia

Registered User.
Local time
Yesterday, 16:43
Joined
Jan 29, 2011
Messages
215
Please Help of Implementing Sequential Numbering Auto "Bar-Code"

I need that Bar-code automatically assigned to a new record when registering.
Here is the Standard Example: 5555-01-001
1. Barcode Must be only in Numbers (Minimum 9 digits)
2. First 4 digits are fixed numbers (Must not be changed)
3. Second Digits are the category of the product (01 - Office Appliances, 02 - Furniture, 03 - Motor - Vehicle, 04 - Consumables)
4. And the last is Sequential numbering (001, 002, 003 etc...)

Thank You In Advanced
 

John Big Booty

AWF VIP
Local time
Today, 09:43
Joined
Aug 29, 2005
Messages
8,263
Have a look at the attached it should give you some pointers.

Note that all that is stored is the raw auto number and the Order number is constructed at the time of display. Your situation would be the same.
 

Attachments

Dairy Farmer

Registered User.
Local time
Today, 02:43
Joined
Sep 23, 2010
Messages
244
Remember that if you are going to actually make bar codes then they cannot simply be sequencial (simplified answer). Unless certain formats are used (i.e. Coad39 bar codes).

Bar codes should have a check digit in then to avoid miss typing a single digit and getting the wrong item.

http://electronics.howstuffworks.com/gadgets/high-tech-gadgets/upc.htm

Example (not using actual validation/check digit. for illistration only):
5555-01-001 and 5555-11-001 (second bar code is mis typed/scanned)

The user enters / scans a bar code, but there is a finger error or a dirty/damaged bar code. By getting 11 instead of 01, the bar code will not validate. 5555-01-001 or 5555-11-123 or 555-11-275 is valid. 555-11-001 is not.
 
Last edited:

vdanelia

Registered User.
Local time
Yesterday, 16:43
Joined
Jan 29, 2011
Messages
215
Hello Dairy Farmer
Thanks For The Full Explanation about the Bar-codes
I need Sequential Numbering, Which will be assigned to the products automatically (With Specific format, based on my products category 01, 02, 03, 04)
I found a good example it does100% what I need, but i couldn't use it in my database (My database uses relationships and are normalized)
Please See my Database on Attachment

Can anyone help me configuring this example for my needs

Example Link:
http://www.techonthenet.com/access/modules/sequential_nbr2.php
Download Link: http://www.techonthenet.com/access/downloads/sequential_nbr2.zip

Thank you In Advanced
 

Attachments

Last edited:

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom