Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
validation error despite cancel in beforeupdate
I have a data-entry form with one bound text field to receive a number from a barcode scanner. The BeforeUpdate event for this field contains code to verify that the ID number scanned is valid: Private Sub barcode_BeforeUpdate(Cancel As Integer) If DCount("*", "barcode name", "barcode=" &...- ramzoid
- Thread
- Replies: 9
- Forum: Microsoft: Access Forms
-
Calculated text box and variables
I am trying to use an unbound text box to display a message based on the contents of a data-entry text box. In the sub associated with the data-entry box, the message text is stored in a string variable, sMessage. I tried simply putting =[sMessage] in the control source for the unbound box...- ramzoid
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
-
display confirmation of input in data entry form
Warning: question from a beginner Context: A user with a barcoded ID card will use a simple data-entry form to "clock in" and "clock out" their arrival/departure by scanning their barcode. Problem: I want to give the user visual confirmation of their input; specifically, the user will enter a...- ramzoid
- Thread
- Replies: 5
- Forum: Microsoft: Access Forms
