MS Access database Help

[David]

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]

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
*-----------------------------------*/

[David Johnson]

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!