Solved

Event Trigger based on Input Length

Posted on 2014-01-13
9
437 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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Archiving Access table older than 6 months 9 39
Should I keep recordsets open? 3 24
My SQL as Backend for Access 3 18
Dcount help 2 17
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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…

810 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