Search results

Hi GaP42.....i basically want to be able to parse the barcode into the following fields in a table. BarcodeNo BBDate BatchNo ProductID The database is for traceability where we can use queries to go back and track what products we used, their batch numbers and shelf life info. There is only...

No they're not padded out in the code. The barcodes in the post above i actually used the scanner to do them on the screen. Yes the bracketed values are always the same

Yes (240) always precedes the Product ID. The two barcodes below are sitting on my desk and you can see the one at the bottom is actually longer so they're not always the same 1524011410612768240AD23051274 15240502107051533240AD86515786

There are 2 'threes' before the 240....not sure if these are special characters ? The link is blocked here where i work so can't check it online

Thanks Josef, looks promising. I have a couple of questions : I scanned in the barcode below and it didn't separate the batch number from the product ID ? Also, how do i get the results saved into a table ?

Fair enough Josef but i still have the problem of extracting the content from the barcode to the database. From reading a couple of the other posts, this would be easier if the delimiters were symbols....but i'll see what they come back with

Just an update guys.....i've contacted the manufacturer of the scanner to see if it's possible to change the delimiters from numbers to some sort of symbol like an asterix or something. It's a long shot but i can't see this being solved as long as those numbers are in the barcode.

I have zero knowledge of VBA....what do i do with that code ?

I'm not sure Josef and nobody i've asked is sure either. Our IT dept thinks it's EAN 128.

When the barcode is scanned into Access, those numbers do appear but not in brackets. The brackets only appear when it's printed. I would've thought that using numbers as delimiters wasn't the best idea

Thanks Mark.....this sounds great and hopefully it would solve the problem. Unfortunately i honestly wouldn't have a clue how to implement this method....it's a mile over my head with where i am with Access.

Some more info on the scanner. It's a Zebra LI3678 and i managed to get some tech help regarding adding a Tab event after a barcode has been scanned. That's working now, so now i have to work out how to get the information within the barcode into the correct field controls

I'm actually not really sure. I've got somebody looking into it for me. The scanners in use are pretty old and nobody knows much about them

Yes the BB Date is 14/01/2024. That's just the format it's in on the barcode. The batch numbers and even the Product ID numbers will not always be the same length.

Thanks again for your time George. Just to clear something up i'm not trying to scan two barcodes into one field. I was going to create two text boxes on the form (one for each barcode). I have a bit more information now......i'm told there has only been two barcodes for the last 30 yrs and this...

Ok well the first barcode contains the following Product Name Product ID Batch Number The second barcode contains Product Weight Pallet ID Don't ask me why there needs to be two barcodes but i'm stuck with it unfortunately Thanks again for your help

Ok so how do i set up what you're suggesting ?. I'm told there will never be more than two barcodes....and if there is in the future, i won't be there to worry about it !. Are you saying that scanning the barcode and then having the relevant pieces of information from that code separate into the...

How to you get the scanned barcode to separate into the relevant controls on the form ?

Thanks for the suggestion George. I'm not sure a table like that would work in this instance as the barcodes would be different each time even for the same raw material. Batch numbers would change with each delivery, which would be reflected in the barcode.

Hi Guys, I've been asked to create a database which allows Users to scan barcodes on various raw materials being used on site here. I'm not sure if it's a problem but each item has two barcodes which i would like to be able to scan as one record. I was thinking maybe have two fields on a main...