Barcode Input

[Greg]

I've developed an application that will accept data inpurt from a scanner.
The method I've used to take in data and process it is by using the
_AfterUpdate event of a text box contol that has focus. Now, this works well
until the system somehow changes focus to another control on the form. Such
as the user changing the record they are viewing by clicking on a list box.

I cam across one article on the internet suggesting to use the form's
_KeyPress event to and to evaluate for the start and stop characters of an
asterick of a Code 39 barcode. Now, the user we have created the system for
will not necissarily using a code 39 barcode. Taking that into account, is
there any way to ensure the barcode scanner will be accepted as input
regardless of what control has focus?

Or, are there any free downloadable samples of forms that process barcode
scans.

Thanks,

Greg

 

[Charles Wang[MSFT]]

Hi Greg,
I understand that you would like to have your Access application accept
barcode input no matter which control has focus.
If I have misunderstood, please let me know.

Since KeyPress event can capture barcode input, I recommend that you try
manually judging the barcode input in KeyPress event.
This should not be related to code 39 barcode.
There are some discussions regarding this topic:
http://www.codeguru.com/forum/archive/index.php/t-358984.html

Also you may want to use an ActiveX control for doing this. I found some
links and you may see if they are helpful:
Using bar codes in Access
http://office.microsoft.com/en-us/access/HA010345341033.aspx
Download Ocx Software
http://www.filesland.com/download/ocx.html
OfficeBarCode
http://www.officebarcode.com/plug-in-tutorial.html

Hope this helps. If you have any other questions or concerns, please feel
free to let me know.

Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

 

[Tony Toews [MVP]]

I've developed an application that will accept data inpurt from a scanner.
The method I've used to take in data and process it is by using the
_AfterUpdate event of a text box contol that has focus. Now, this works well
until the system somehow changes focus to another control on the form. Such
as the user changing the record they are viewing by clicking on a list box.

My attitude on this to the user would be tough. I'd include a few
specially designed forms for barcode use and tell the user that they
should use those and nothing else.

Alternatively if they do go to lookup an old record lock the controls
on the form until they explicitly unlock.

Locking fields on a form in Microsoft Access
http://www.granite.ab.ca/access/locking_fields_on_a_form.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Charles Wang[MSFT]]

Hi Greg,
Just check with you to see whether the suggestions are helpful. Please feel
free to let us know if you have any questions or concerns.

Best regards,
Charles Wang
Microsoft Online Community Support

======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================