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

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
* (e-mail address removed)
* (e-mail address removed)
*-----------------------------------*/

 

[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.