Finding created Barcode numbers

[IanMilly]

Hi,

I have created a serial number which is turned into a barcode to be used on some of my equipment. The serial number is made up from a letter which indicates the type of equipment, a date (mmyy) and an autonumber.

e.g. A0604000000001 - Type A, June 2004, Number 1

the Field names are CardType, Mandate and SerialNum

The complete (combined) number is created in the form

I want to be able to read the serial number back into the databse (when scanned) and be able to find the exact fields to which this item is linked to or add new linked field items to this number. How can i do this? How can i send the combined number back to a table or at least break the values back into their original format so that i can find the associated records of the piece of kit.

Thank you

Ian

 

[FoFa]

Typically the scanner returns the ascii value of the barcode. All you have to do is capture this value and use it. Now, how this happens depends on your scanner and it's software/interface. And you may or maynot have to strip the leading and trailing barcode delimiter.

 

[IanMilly]

Typically the scanner returns the ascii value of the barcode. All you have to do is capture this value and use it. Now, how this happens depends on your scanner and it's software/interface. And you may or maynot have to strip the leading and trailing barcode delimiter.

I understand that the value returned is an ASCII value, however my problem is that the ASCII value returned will be the full combination of the 3 fields and not values from the individual fields. I do not have the combination of the serial number (A060400000001) stored in a table - how could i either store this value in a table (as the control source is [cardType]&[mandate]&[serialnum] , but not a field value in a table) or can i break the imported serial number into values so that the value can be used to match items to the assigned number.

To make it a bit more clear:
The values stored in the 3 fields are A , 0604 and 00000001.
There is no field in a table with the fulll value A060400000001.
How can i match the scanned value to the values created in the table?

Thanks in advance

Ian

 

[FoFa]

If the values are consistant in length always, and using your example:
CardType = LEFT(barCode,1)
ManDate = mid(barCode,2,4)
SerialNum = RIGHT(barCode,8)

Now you have it in variables and can do what you want with it.

 

[IanMilly]

thanks