Amazing Issue with Access Form

[kamathmanoj]

Hello Everyone,

I have an Access database that is currently being rejigged to have scanning capabilities. The first phase is simple.


Form 1: Scan your ID >> Looks up your name, user confirms it is them (Ok/Cancel) takes them to Form 2




Form 2: Task List >> Click a radio button and your are taken to either enter the raw material OR enter actual observations



Form 3 Tab1 : Enter Raw Material data >> Click New command button
Click the job tab (second tab from the left)



Scan the data matrix bar code into the obvious field in the screen capture below, function on update(), splits the array it receives into different text boxes tied to the recordset and saves it.
I have added the Exit Sub for Exit and Error handling.




When I scan the exact same code on the same database form, it goes through but twice now, my users are seeing the scan(!!) from the Coil tab go into the VBA code in the background.
I cannot replicate this error no matter what I type for the array fields. Every error I can think of is caught by VBA and shown as a dialog box. Can someone think how the user might be bypassing all of this and ending up with the scan inside the code? See the picture of where the scan is ending up below:

[kamathmanoj]

This is list of the barcode and what is going into the array in sequential order:
(P)C22J153AA/54
(V)SDI
(S)1602813901
(K)378155
(1T)B908571
(2Q)31780
(1Q)1095
(Q)1
(ZC).06
(ZMN).51
(ZP).011
(ZS).004
(ZSI).004
(ZAL).02
(T)66.6
(Y)52.6
(E)32
(W)53.2300
(G).1574

If you look at the scanner, which is running an RDP session to the PC that MS Access is open on, notice how the sequence of the entry is changed too and "(" goes missing in the last 4 lines of the scan. It boggles my mind. Please help.

[CJ_London]

Can someone think how the user might be bypassing all of this and ending up with the scan inside the code? See the picture of where the scan is ending up below:

I don't have a solution, but I have seen it happen when using things like keypress events/timers and/or code errors which open the vba window and the vba window is then receiving the input.

[kamathmanoj]

I don't have a solution, but I have seen it happen when using things like keypress events/timers and/or code errors which open the vba window and the vba window is then receiving the input.

I agree, it might happen with multiple scanner button presses, but when the text box is active and the afterupdate event is programmed, what are the chances that a single trigger press, splits part of the scan into the text box, and the remaining into the code? If there was an error in the scan, I have a handler that exits the function. There are no timers set nor keypress events and neither is there a code error that is being seen (which would result in the VBA flashing a "End/Debug/Exit" dialog box, no?

[Micron]

Does your error handler have a generic response for any error that you have not foreseen? If so, are they tripping it and are you logging the error number, description and as many of the variables as possible? This may be a permissions issue or an unanticipated user approach, either of which might cause a variable to be null or empty. I say that because it appears as though you're saying it happens to others but not to you. Secondary might be your break option in the vbe editor, such as "break on all errors" rather than just unhandled ones.

[CJ_London]

such as "break on all errors" rather than just unhandled ones.

good point - I've been caught out with that in the past

[kamathmanoj]

Thats sensible, I have the error capture - its Error 9, subscript out of range. And I found out something new today. I am onsite. I find that when I scan to a notepad instance and then paste the output into the text box, it works fine but when I scan to the field, its giving me a subscript out of range error. Ideas?

[CJ_London]

its giving me a subscript out of range error. Ideas?

none that spring to mind. The error normally relates to arrays/collections/dictionaries

https://docs.microsoft.com/en-us/off...-range-error-9

[kamathmanoj]

none that spring to mind. The error normally relates to arrays/collections/dictionaries

https://docs.microsoft.com/en-us/off...-range-error-9

Thank you Ajax. Indeed it was! The company adding the bar code, added a Horizontal Tab at the end of the expected string causing the Access data to flow in as multiple strings. I contacted the scanner technical support to check if we could do something to remove it but given that these were not part of the initial work-flow, we have asked the bar coder to remove the <Horizontal Tabs>. It works fine now. Wonder what they will cook up next! LOL

[CJ_London]

glad you got it sorted