I will be scanning data for 2 text fields with a handheld device.
Here's an excerpt from my question I will be asking next:
1. I've somehow got to tell Access I'm about to enter some information and it needs to know where to put it. That's my first major hurdle because I don't have any idea where to begin.
2. Scan barcode. Check number of digits. It is 5 digits. It knows it has just read a CUST_NUM.
3. Look for that CUST_NUM's LastOrder. This might be a start. (thanks topher23)
Expand|Select|Wrap|Line Numbers
- Dim LastOrder As Long
- LastOrder = Nz(DMax("ORDER_NUM", "tblOrders", "CUST_NUM='" & _
- Me.CUST_NUM & "' AND ORDER_NUM < '" & Me.ORDER_NUM & "'"), 0)
If I want to scan data from a scanner/handheld device, does it make more sense to try to send data to a form, or straight to the table? The user will not really be interfacing with the computer while scanning the data. What makes more sense?
Thanks for your input, advice, and/or suggesions. :-)