A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to automatically move to next field after Bar/EAN code entry?



 
 
Thread Tools Display Modes
  #1  
Old March 21st, 2010, 01:58 PM posted to microsoft.public.access.forms
Rick Brandt
external usenet poster
 
Posts: 4,354
Default How to automatically move to next field after Bar/EAN code entry?

Stephen8667 wrote:

Table Columns: EAN Code; Product Name; Order Qty
Form Fields: EAN Code as a combo box; Product Name (No Tab stop); Order
Qty. Question: The cursor is in the Cbo Box. I am using a Bar Code scanner
to read the code from the sales packet which I want to order. The numercal
bar code is located from the Cbo Box list and is selected. Using the
"After Update" event procedure, the Product Name field then shows the
product name related to that code. I would like to then manually enter the
number of pieces I want to order into the Order Qty field. The problem is
that the cursor remains in the Cbo Box and doesn't move to the next field
until I press the enter button. What must I do to get the cursor to move
to the Order Qty field once the scanner has read the product code, without
having to press enter? Thanks in advance for your reply, Stephen. PS:
PLease answer in basic instructions as I'm not an advance user.


Just about all scanners can be configured to automatically issue an Enter
or Tab keystroke at the end of each scan. If your field is always the
same length you might be able to use the AutoTab property of the control.

  #2  
Old March 21st, 2010, 05:08 PM posted to microsoft.public.access.forms
Stephen8667
external usenet poster
 
Posts: 1
Default How to automatically move to next field after Bar/EAN code entry?

Table Columns: EAN Code; Product Name; Order Qty
Form Fields: EAN Code as a combo box; Product Name (No Tab stop); Order Qty.
Question: The cursor is in the Cbo Box. I am using a Bar Code scanner to
read the code from the sales packet which I want to order. The numercal bar
code is located from the Cbo Box list and is selected. Using the "After
Update" event procedure, the Product Name field then shows the product name
related to that code. I would like to then manually enter the number of
pieces I want to order into the Order Qty field. The problem is that the
cursor remains in the Cbo Box and doesn't move to the next field until I
press the enter button. What must I do to get the cursor to move to the Order
Qty field once the scanner has read the product code, without having to press
enter? Thanks in advance for your reply, Stephen. PS: PLease answer in basic
instructions as I'm not an advance user.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.