It works great when I "cut and paste" into each field on my computer, but hangs in both fields when I use the barcode reader out on the production line on their computer.
I like the idea of having the barcode reader send the "enter" commands. I will look into that.
As for errors, I want it to...
Well, that hasn't worked yet. It works on my computer when I cut and paste numbers in the fields, but it looks like the barcode reader reads numbers individually, so the "Change" command changes on the first character in the serial number, but the last number. Also, it reads the part number, but...
Here is what I have now.
Private Sub Part_Number_AfterUpdate()
SendKeys ("{TAB}"), True
End Sub
Private Sub Serial_Number_Change()
SendKeys ("{TAB}"), True
End Sub
I have added a part numbers table, and on the form, I am using a drop down box for the part number. If an incorrect part number...
At the end of an assembly line, I am currently tracking parts using 2 pieces of bar-coded information, the part number and the serial number of each part. We currently have a Symbol LS 1902F scanner reading the information into an Excel spread sheet. After one barcode is read, we have to press...
At the end of an assembly line, I am currently tracking parts using 2 pieces of bar-coded information, part number and serial number for each piece. We currently have a Symbol LS 1902F scanner reading the information into an Excel spread sheet. After one barcode is read, we have to press "tab"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.