Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Event Trigger based on Input Length

Posted on 2014-01-13
9
Medium Priority
?
448 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

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 52

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 52

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 52

Expert Comment

by:Gustav Brock
ID: 39777776
You are welcome!

/gustav
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

604 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