Search results

Adding DoEvents is what did the trick. Still being new to the coding side of Access I am not really sure why that fixed it except to say it returns control. Is this correct or will you explain further?

Got it working! Thank you vbaInet and JHB. Appreciate your help. Private Sub Form_Error(DataErr As Integer, Response As Integer) 'MsgBox DataErr 'Display TryAgain image and clear combobox with focus back in combobox Select Case DataErr Case 2237...

Thank you JHB. I will keep working at it.

I'm new to coding in Access. I was following the template of the Sub Form_Error and that is why On Error Resume Next is in the code. I will remove it all together if I don't need it. As for the form not displaying, I stating for it to be visible and then after the delay for it to not be visible...

I checked to see what the error is when scanning for the equipment and it is 2237. When I scan an invalid badge ID the "Try Again" form appears, the txtEXEID clears, and the delay happens for about 3 seconds. Then I scan a valid badge ID and the focus moves to Scan Equipment. When I scan...

I'm not sure what you mean by "Your focus should be on the scanning process itself". Can you explain? I have tried the NotInList Event for both of these comboboxes but have not been successful so when I got to work on the Form On Error I was excited about that.

What's not working is the image displaying when the second combobox is scanned incorrectly. The user will only have a scan gun. They scan their badge for the cmbEXEID box and if their badge is not recognized then the image Try Again will display for 5 seconds and they can scan a valid badge. The...

I'm using a Sub Form_Error and Select Case to look for specific errors. I have two comboboxes and when the error is recognized I have an image display. This works fine when cmbEXEID is scanned incorrectly but does not work when the cmbEquipEXEID is scanned incorrectly. Here is the code I have...

That worked to clear the label not defined error. Thank you. If the entries are okay can I put that code in the Not In List event or do I need to have a Before or After Update event as well? When the EXE ID is valid I have a green check mark replacing the red x. Something like this: Private...

The name of the combobox is cmbEXEID. Can you explain what you mean by control name? I had a textbox (named txtEXEID) over the cmbEXEID but when I removed that I still got the same error. I also have another combobox (cmbEquipID) without a textbox over this one and I placed the same Not In List...

I am still getting a "label not defined" error. The first line of code below is what highlights when the error runs. Here is the code I entered: Private Sub cmbEXEID_NotInList(NewData As String, Response As Integer) On Error GoTo cmbEXEIDNotInList_Error If IsNull(cmbEXEID) Then...

Great tutorial you provided. Thank you. Do I have the code right? I am now getting a "Label not defined" error. Private Sub cmbEXEID_NotInList(NewData As String, Response As Integer) On Error GoTo cmbEXEIDNotINList_Error Dim NewcmbEXEID As Long If IsNull(cmbEXEID) Then...

I have a simple form with two comboboxes, one for badge id and one for equipment id. There is one textbox which is for the action being performed. The user will use a scan gun to populate each of these by scanning the barcode on their badge, the equipment, and a label for the action. The form...

Thank you. Closing the brower worked.

I'm new to this forum (and forums in general). I'm trying to post to the forms thread but keep being sent to the login screen. I then log in and redirected back to the same screen. Can I post only on certain threads? Thank you

I have been working with Access (2003) for about 10 years now. I have built several databases where I work but have not worked with any coding. Just earned a software engineering degree and am starting to dabble in programming to build and improve my skills.