By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,673 Members | 1,268 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,673 IT Pros & Developers. It's quick & easy.

MS Access database Help

P: n/a
I have an inventory program. I want to scan a barcode,
which will then run a queuery on a MS Access table and
from that queuery populate the data text boxes.

Here is a step through:

1. Scan Barcode
2. Barcode dumps number to text box
3. Scanner sends a tab to the computer
4. On Tab, queuery is run on barcode number
5. Data retrieved for Part #, # on hand, Price, etc., and
put into correct text box on screen
How do I get the queuery to run on Tab?
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Here's one strategy:

1. Set focus to the text box.
2. Do your scan.
3. When the form receives a TAB, it should (??) cause the text box to go
through a LostFocus event.
4. Over ride the lost focus event handler to do your query, then continue
with the normal handling.

Hope this helps.

-tomas

David wrote:
I have an inventory program. I want to scan a barcode,
which will then run a queuery on a MS Access table and
from that queuery populate the data text boxes.

Here is a step through:

1. Scan Barcode
2. Barcode dumps number to text box
3. Scanner sends a tab to the computer
4. On Tab, queuery is run on barcode number
5. Data retrieved for Part #, # on hand, Price, etc., and
put into correct text box on screen
How do I get the queuery to run on Tab?


--
/*-------------------------------------
* Tomas Vera
* ta****@sbcglobal.net
* to********@tapeware.com
*-----------------------------------*/

Nov 13 '05 #2

P: n/a
Great! I have it working right now with all of the text boxes but you
have to press a key to get it to run the query.

I will work on getting the Focus/Lost Focus (never messed with that) set
up and working.

I am having one issue with my textboxes:

I want to ONLY accept numbers (integers) into the Barcode textbox. Is
there a way to do that? I have been searching TechNet but to no avail.
Thanks again for the help. It is greatly appreciated.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.