?
Solved

Event Trigger based on Input Length

Posted on 2014-01-13
9
Medium Priority
?
443 Views
Last Modified: 2014-01-13
I  am writing a very simple database in which one field is read by a USB barcode scanner...which simply acts like a keyboard input.

I need someway to have and event triggered once this data is input, as all barcode data would be the same length , testing the length should be the trigger to move to next record or some other action.
0
Comment
Question by:shelbyinfotech
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
9 Comments
 

Author Comment

by:shelbyinfotech
ID: 39777012
The OnChange Event fires when the code is scanned, however, it does not all the text to go in the box . ....... ?
0
 
LVL 10

Expert Comment

by:Anthony Berenguel
ID: 39777023
Can you post your OnChange event code?
0
 

Author Comment

by:shelbyinfotech
ID: 39777039
Just started....wrote a macro to test the event ....similar action with OnDirty.Event as well
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 

Author Comment

by:shelbyinfotech
ID: 39777057
In either event, I issue a RunCommand SaveRecord...which only returns a zero to the text box
0
 
LVL 51

Expert Comment

by:Gustav Brock
ID: 39777104
Most barcode scanners can be set to add a linefeed after the scanned code.
The you can use the AfterUpdate event of the textbox.

/gustav
0
 

Author Comment

by:shelbyinfotech
ID: 39777218
Do you know of a particular one Gustav ?
0
 
LVL 51

Accepted Solution

by:
Gustav Brock earned 2000 total points
ID: 39777267
Datalogic, but it is many years ago. My impression was that this feature was quite common.

/gustav
0
 

Author Closing Comment

by:shelbyinfotech
ID: 39777505
After matching the ones we had in house to a current manufacturer ( Symbol is now Motorola )  , I was able to find the manual and reconfigure the devices.

Thanks
0
 
LVL 51

Expert Comment

by:Gustav Brock
ID: 39777776
You are welcome!

/gustav
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses
Course of the Month11 days, 2 hours left to enroll

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question