troubleshooting Question

Allow only barcode scanner to input data into an Access text field

Avatar of joe_GDB
joe_GDBFlag for United States of America asked on
Microsoft OfficeMicrosoft AccessMicrosoft Applications
24 Comments1 Solution5223 ViewsLast Modified:
I am trying to set up a text field in Access to allow only barcode scanner input.  I came accross the following post that seems to be my only solution, however my VBA skills are somewhat limited.  How would I code the solution suggested in the last paragraph.

"The only difference between keyboard and barcode-reader is the typing speed ...
Try measuring the time needed to insert the digits of the barcode and clear the field if typing is too slow"

"Simply remember the time of the last editing of the text in the textbox and compare it with the time of the current update.
You can use the function Now for this
And the calculate the difference with DateDiff function"
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Database Architect / Application Developer
Join our community to see this answer!
Unlock 1 Answer and 24 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 24 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros