This scenario is based on a POS touch screen where you cannot see any keyboard for data entry, now in MS Access we built a Keyboard unbound form to assist in capturing data. The reason why we did it that way is that there are some situations when the scanner fails to scan the barcode, and so the option or method used is to enter the barcode manually. That is okay if there is a keyboard but without a keyboard it’s almost impossible to do it.
I have assisted the users to transfer the captured data into the required scanning control using this method below, but it does not go into the subform datasheet rows, that is where my problem is, any idea here will be highly appreciated.
To appreciate the question above kindly get the database attached and simply go to properties and check the unblock field then it will open. For the keyboard to work simply compile the code.
I have assisted the users to transfer the captured data into the required scanning control using this method below, but it does not go into the subform datasheet rows, that is where my problem is, any idea here will be highly appreciated.
Code:
Private Sub BtnEnterKey_Click()
Forms!frmCustomerInvoice!txtProductCode.Value = Me.Calc
End Sub