Solved

Event Trigger based on Input Length

Posted on 2014-01-13
9
436 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
Comment Utility
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
Comment Utility
Can you post your OnChange event code?
0
 

Author Comment

by:shelbyinfotech
Comment Utility
Just started....wrote a macro to test the event ....similar action with OnDirty.Event as well
0
 

Author Comment

by:shelbyinfotech
Comment Utility
In either event, I issue a RunCommand SaveRecord...which only returns a zero to the text box
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 49

Expert Comment

by:Gustav Brock
Comment Utility
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
Comment Utility
Do you know of a particular one Gustav ?
0
 
LVL 49

Accepted Solution

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

/gustav
0
 

Author Closing Comment

by:shelbyinfotech
Comment Utility
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
Comment Utility
You are welcome!

/gustav
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

763 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now