RE: BarCode Input
- From: Greg <AccessVBAnet@xxxxxxxxxxxxxxxxx>
- Date: Fri, 29 Dec 2006 07:02:01 -0800
Your comments are what I discovered through more testing during the day and
you are correct. My scanner does include the TAB/ENTER character at the end
so the AfterUpdate Event of the text box appears to fire off.
Thanks for the suggestion on setting the height to ZERO. I didn't think of
that one.
Thanks for the help.
Greg
"Peter Yang [MSFT]" wrote:
Hello Greg,.
As I know, many barcode scanners work by plugging into the keyboard port so
the scanned "word" appears to the PC the same as if the characters were
typed via the keyboard. In this case, no special programing is required
for the Access program.
If there is no textbox on a form, Form_KeyPress Event may not work as you
expect. YOu may try to add a dummy textbox on the form with height/width=0,
and set focus to it when the form loads. For the change or other events,
you could get the barcode information and then try to do thinngs in other
forms as you want:
Private Sub Form_Load()
Text1.SetFocus
End Sub
Private Sub Text1_Change()
' do what you want from here
'MsgBox Text1.text, vbOKOnly
End Sub
When a textbox is set to "invisible", it is not to "setfocus" and you
cannot get the barcode information then.
Please see the following article for some useful informaiton about barcode:
http://www.granite.ab.ca/access/barcode.htm
Many scanners can be set up to include a <Tab> or <Enter> at the end of the
scanned data so that sometimes you just place the focus in the desired
TextBox, scan the barcode, and the data automatically is entered and the
focus automatically moves to the next field.
If you have any comments, please feel free to let's know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
- References:
- RE: BarCode Input
- From: Peter Yang [MSFT]
- RE: BarCode Input
- Prev by Date: Re: not in list open a form
- Next by Date: Re: not in list open a form
- Previous by thread: RE: BarCode Input
- Next by thread: Re: SUM Calculation in Mainform from data in Subform
- Index(es):
Relevant Pages
|
