Search results

Yes sir, you are correct. The existing entries in tblPackout!Barcode just tests, me trying to get a value into LMBarcode, there will be no duplications allowed in the production db. The barcodes will always be a total of 12 numeric characters.

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...

Well apparently I don't need to worry about any of that because I can set the input mask of the textbox to 000000000000... only the numeric characters and yes, 12 of them. Cool.

I'm thinking the problem is not with the Replace but with the item I'm trying to replace. Let me try to be more specific... Starting with a form I scan a barcode into txtBarcode which has a control source of Barcode (a field in tblPackout). The barcode scanner sends the the data (with it's...

Good thought Gasman but I know I'm using the correct symbol, I programmed the scanners.

Thanks for replying CJ, but unfortunately neither of those worked.

Hi Folks. Apologies if this is not the right forum. I'm working on a solution to scan barcodes into a table. I setup a form with a textbox and it's control source is tied to a field in my table. The scanner I'm working with is programmed to add characters to the scanned value so 012345 is...

Hi Folks. Happy to be here. Lots of Excel experience but very little in Access so please be kind.