Hi all
Can anyone please help me to solve this issue below, that will be great.
I have MSaccess 2007.
I have employees who scans label bar codes via ms access vba. The program end when they scan "END". every time they scan one bar code it goes to a table. Pretty straight forward. I have writen the code as well.
Now they want to see the bar codes they scanned on the same screen as well.
What I did is created 15 text boxes, Named them as TEXTLP1, TEXTLP2, TEXTLP3,...TEXTLP15
I want the program to populate the bar codes each time they scanned into these text boxex TEXTLP1, TEXtLP2.
How can I do this?
here is my exsisting codes,
Dim plp as string
Do While Not plp = "END"
plp = InputBox("ScanLP", "Scan_LP")
If plp <> "END" And Len(plp) <> 20 Then
MsgBox "Invalid LP scanned"
Else
If plp = "END" Then Exit Do
qclp.AddNew
qclp.Fields("PickerLP") = plp
qclp.Fields("PickerName") = pickername
qclp.Fields("PickerDate") = Date
qclp.Fields("PickerTime") = Time
qclp.Update
<---Here I want to add a code to write the "PickerLP" (variable name plp) to the first TEXTLP1 --->
Your help is much appreciated.
Thanks