Hello everyone, I created a simple access table for our receiving department and a form with the following fields: Receiving Date, Time, Courier, and Tracking Number. I need help with what it should be a simple code that counts the number of scanned Tracking Numbers each time a delivery is made (our scanners automatically press enter when a scan is made). We receive between 45 to 70 packages multiple times a day and I would like a number on the form that shows how many tracking numbers were scanned and then I guess a button to reset the counter to zero?
I tried the code below that I found in the forums. Thank you in advance, hope someone can help.
- This one only gives me total records
Private Sub Form_Current()
Me.BoxCount.Caption = _
Me.Recordset.RecordCount
End Sub
- The ones below should work but I cannot see the numbers
Private Sub Tracking_Number_Enter()
Me.BoxCount = Me.BoxCount + 1
End Sub
Private Sub Tracking_Number_AfterUpdate()
Me.BoxCount = Me.BoxCount + 1
End Sub
I tried the code below that I found in the forums. Thank you in advance, hope someone can help.
- This one only gives me total records
Private Sub Form_Current()
Me.BoxCount.Caption = _
Me.Recordset.RecordCount
End Sub
- The ones below should work but I cannot see the numbers
Private Sub Tracking_Number_Enter()
Me.BoxCount = Me.BoxCount + 1
End Sub
Private Sub Tracking_Number_AfterUpdate()
Me.BoxCount = Me.BoxCount + 1
End Sub