show records in query result without pressing tab

[shod90]

Dear Gents,


Um working on a supermarket database , program flow goes as following:
1- The cashier bring the product and read it's barcode via barcode scanner in the product Code text field.
2- He should press Tab to run the query and find the result of that code.
3- He should press another tab to enter a new item in another row.

Now i need to make the tab button runs automatically when the code of product has been scanned with the scanner to find the product description and it's price one he passes the product through the scanner.

Thanks.

[ranman256]

a few problems:
1. this may not work automatically, Access will not know when the scanner is finished.
This is a 3rd party tool that enters data into a box ,so Access wont know its finished to move foreward.
Someone must press tab/enter to signal access..'next'.
So the tab must be pressed.

2. this may not work on a query result datasheet.
you may HAVE to use a form. The form can show the barcode box, the description box.
set the Description textbox property TAB STOP = FALSE. Then when tab is pressed, the cursor wont go to the next box, it will goto the next record for the next scan.

3. pressing TAB can fire the Afterupdate event. This will run a Dlookup to fill in the description box. BUT this event can be ignored here and done later.
Instead of filling in description at barcode scan, you can run an update query AFTER all items are entered to fill in all null descriptions at once.

[shod90]

First , Thanks for the fast response .
Second: I already done number 2 and number 3 in your reply .
Regarding the third party that do what i need , Is there a specific program name that should i use ?

[ranman256]

Can the scanner be set to produce an 'ENTER' (or tab) keycode at the end of the scan?
this may trigger Access to move forward as if tab was pressed.

[shod90]

To be honest , I didn't try yet the scanner cuz i didn't purchase it yet , Lol .. But if it's not producing Enter or Tab , What will be the solution ?

[Missinglinq]

Most scanners can, I believe, be set to deliver a given, special character after the scan is completed, and this can be used to trigger an event...but this will be scanner specific and you'll need to look at the particular scanner's documentation or contact the manufacturer to determine how to do this.

Linq ;0)>

[shod90]

cool , I'll let u know when i receive it .. Thanks for response guys