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
Solved

Event Trigger based on Input Length

Posted on 2014-01-13
9
438 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
  • 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

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 49

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 49

Accepted Solution

by:
Gustav Brock earned 500 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 49

Expert Comment

by:Gustav Brock
ID: 39777776
You are welcome!

/gustav
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

792 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