Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / January 2005

Tip: Looking for answers? Try searching our database.

Access barcode capture

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Chuck C - 28 Jan 2005 22:03 GMT
I would like to scan into a form and automatically advance to the next
control.  I have tried a me.nextcontrol.setfocus in all the events without
success.  Is there another way?  Thanks!!!
Chuck C - 28 Jan 2005 22:39 GMT
Let me clarify...I scan a barcode with a wedge scanner into a control.  
Instead of requiring the user to tab to or click in the next control, I'd
like Access to automatically advance.  thanks

> I would like to scan into a form and automatically advance to the next
> control.  I have tried a me.nextcontrol.setfocus in all the events without
> success.  Is there another way?  Thanks!!!
Paul Overway - 28 Jan 2005 22:51 GMT
A lot of barcode scanners allow you to specify a termination character.
Have you looked at that?  In any case, you need to know what character the
scanner sends to represent the end of field.  If you have the scanner set to
use tab as the termination character, you wouldn't need to do anything.  If
it uses a different termination character, you'd have to use the KeyPress
event to trap the EOF character, set KeyAscii = 0, and .Setfocus to the next
control.

Signature

Paul Overway
Logico Solutions
http://www.logico-solutions.com

> Let me clarify...I scan a barcode with a wedge scanner into a control.
> Instead of requiring the user to tab to or click in the next control, I'd
[quoted text clipped - 4 lines]
>> without
>> success.  Is there another way?  Thanks!!!
Michel Nault - 29 Jan 2005 13:55 GMT
I've ran some testing with bar code readers and the termination character can
be set to send the "Enter" character.  You simply need to set the "Enter"
action of the control box to move to the next field.

> A lot of barcode scanners allow you to specify a termination character.
> Have you looked at that?  In any case, you need to know what character the
[quoted text clipped - 12 lines]
> >> without
> >> success.  Is there another way?  Thanks!!!
Paul Overway - 29 Jan 2005 19:24 GMT
Yes...that works too...sometimes.  The problem being that if focus is
somewhere that it shouldn't be when you do the scan, you may have an
unintended/undesired effect...i.e., focus in on cancel button, you
scan...guess what.  If you use tab, this is less of a problem.  If you use
some other character, i.e., ASCII 0 or some high ASCII number, it is even
less of a problem.  But it depends on the scanner.

Signature

Paul Overway
Logico Solutions
http://www.logico-solutions.com

> I've ran some testing with bar code readers and the termination character
> can
[quoted text clipped - 22 lines]
>> >> without
>> >> success.  Is there another way?  Thanks!!!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.