I am developing a scanning database in MS Access 2010 and using Symbol/Motorola LS 4278 Bluetooth Barcode scanners.
Some of the barcodes I scan work perfectly but some only repeat the data from the previous line in the table. Almost as though there is something in these barcodes that copies the line above... It sounds crazy and is a little difficult to explain.
When scanning you can see the correct data going across the field, it then disappears and is replaced by the data in the field above.
I have created a brand new table in a blank database and it still occurs. In Excel or Foxpro database it works perfectly.
I have attached an example of the problematic code. Not sure if its res will be good enough though.
Any ideas would be gratefully received.