Edit results when Scanning a Barcode (serial number) into a form.

[IannWard]

Hi

I have created my first database to log serial numbers of certain devices. Device 1 has a 12 digit serial number which is fine, but device 2 has an 18 digit number with a few letters in the middle. Is there any way, when scanning the barcode in to a form, that access recognises it as an 18 character serial number but ignores the first 6 digits to just display the last 12?, also if it is a 12 digit serial number from device 1 it just displays all characters?



Hope this makes sense..

Many Thanks

[Dal Jeanis]

My suggestion is to scan it into an 18 digit control field, and use the onchange event of the control to calculate the 12 digit code into another field.

[IannWard]

Thank you for your quick response. That sounds great, but as a newbie, could you explain a little more about a control field and onchange event please.

Thanks

[June7]

A control is something you put on a form - textbox, combobox, button, label are all controls of various types.

I think Dal meant scan the barcode into a textbox control that is bound to a field. An expression in another textbox can extract the 12 characters, like:

=IIf(Len([scan box name])=18, Mid([scan box name],7), [scan box name])

If you want to save that calculated result to table, will require code.

[Dal Jeanis]

Pretty much. Your barcode scanner needs to put the scan results into a field. I cant tell you how to do that, because it's basically a hardware thing.

Let's say it's a textbox that's getting the results, and the name of the textbox is txtBarInputCode.

In the txtBarInputCode_Change event, you will have code that deits and strips down the value that just got loaded into the textbox, and inserts that calculated value into another control. The OTHER control is the one that will be bound to the database field.

Now, not knowing what you are going to DO with the data, I can't tell you how that code needs to look.

My suggestion is, first step, figure out how to get the barcode to scan its result into a field on a blank form. Until you can get it to do that, without triggering anything, you really can't do anything at all.

Once you know how to make the scanner input something, then the rest should be really easy.

[IannWard]

A control is something you put on a form - textbox, combobox, button, label are all controls of various types.

I think Dal meant scan the barcode into a textbox control that is bound to a field. An expression in another textbox can extract the 12 characters, like:

=IIf(Len([scan box name])=18, Mid([scan box name],7), [scan box name])

If you want to save that calculated result to table, will require code.

Hi

I scan the barcode into an unbound text box and it displays like this 29384PP71161047. But I only want the numbers after the two P's. All my serial numbers in the database are just the last 8 digits (this is because another database in the company displays them this way, so I wanted to keep them the same in mine), but when I scan the barcode, I have to manually delete the first 7 characters before I can then hit search to find the serial number and other data linked to it. If that makes sense....

[June7]

Did you try the suggested expression and code to save?