By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,161 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Should scanned data go into a form or into a table?

100+
P: 256
I'm trying to write a complicated question for Bytes. In order to make it more cohesive, I need to ask a pre-question. LOL.

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
  1. Dim LastOrder As Long
  2.  
  3.     LastOrder = Nz(DMax("ORDER_NUM", "tblOrders", "CUST_NUM='" & _
  4.  Me.CUST_NUM & "' AND ORDER_NUM < '" & Me.ORDER_NUM & "'"), 0)
4. Scan another number. Check number of digits. It is 3 or 4. It knows it has just read a BOX_NUM. Put the number it just read into BOX_NUM1, BOX_NUM2 (which are located on the same form as LastOrder from step 3), etc until another 5 digit number is scanned. When another 5 digit number is scanned, start over with step 1. Continue until user goes back to computer and does something to tell computer to stop scanning. (button, escape, save, etc)

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. :-)
Apr 22 '10 #1

✓ answered by missinglinq

First off, all data entry should be done thru forms, never directly into tables.

I've never used a scanner, but as I understand it, a scanner is a data input device, just as the keyboard is, and all you should have to do is place the cursor in the textbox on the form then scan.

Linq ;0)>

Share this Question
Share on Google+
2 Replies


missinglinq
Expert 2.5K+
P: 3,532
First off, all data entry should be done thru forms, never directly into tables.

I've never used a scanner, but as I understand it, a scanner is a data input device, just as the keyboard is, and all you should have to do is place the cursor in the textbox on the form then scan.

Linq ;0)>
Apr 22 '10 #2

100+
P: 256
Perfect Info Linq. Exactly what I was looking for. You are right about the scanner, it reads numbers like if you typed them in via keyboard.

Thanks a billion.
Apr 22 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.