Hi Folks.
I feel like this should be that difficult but for the life of me I can't figure out how to take the value entered into a form's textbox via a barcode scanner and place it into more than one field in a single table. I've tried a variety of events... BeforeUpdate, AfterUpdate, KeyPress, Enter, I've tried using event procedures and queries but nothing seems to works. My ultimate goal is to scan a barcode, have it entered into one field, and then entered into another field but truncating the value by removing the last two characters of the input. It shouldn't be that complicated...
A barcode is scanned into a text field on a form that is bound to a field in my table... the barcode scanner is programmed to scan then send an enter event which is used by Access to perform a 'nextrecord' function. I'm attaching my working version to this post in hope somebody who knows a bit more than I will take a look and say 'oh, here, this is you're problem...' Any help or direction is greatly appreciated. - thank you.
I feel like this should be that difficult but for the life of me I can't figure out how to take the value entered into a form's textbox via a barcode scanner and place it into more than one field in a single table. I've tried a variety of events... BeforeUpdate, AfterUpdate, KeyPress, Enter, I've tried using event procedures and queries but nothing seems to works. My ultimate goal is to scan a barcode, have it entered into one field, and then entered into another field but truncating the value by removing the last two characters of the input. It shouldn't be that complicated...
A barcode is scanned into a text field on a form that is bound to a field in my table... the barcode scanner is programmed to scan then send an enter event which is used by Access to perform a 'nextrecord' function. I'm attaching my working version to this post in hope somebody who knows a bit more than I will take a look and say 'oh, here, this is you're problem...' Any help or direction is greatly appreciated. - thank you.