I have developed an relational inventory database that when a six digit code is entered, then I "leave the field" (Tab, new record, etc) the related data on this item appears. I am now using a laser gun to read barcodes to enter the six digit code and I would like for a new record to be generated automatically (no keyboard entry) after each scanned entry. The bar codes are already set so I cannot place a CTRL-N in them. How do I do this?

set a script that does this:

Loop

If [Length(bar code) = 6]

New Record/Request

Pause/Resume (3 secs.)

end if

end loop

you can have the pause resume as long as it takes you to scan the next item, if that means you have to wait 15 secs, then just specify that, or whatever you need. i wouldn't think you'd need very long if that is all your doing is scanning. i would also run it on open, but if you did that, include the script step, go to last record before the loop (as the first step) or else you'll just keep entering new records. in order to exit script, i just through a exit script if (status(currentModifierKeys) = 1. but you can do it however you want.

You can program your bar code reader to place a "tab" character or a "enter" every time you scan a barcode, check the scaner manuals.

ZZ

Thanks for the responses. The last first: I am using a Wasp Laser gun and I tried the pre programming but it has a limited ASCII base. I also have a CCD scanner and I have preprogrammed it. The loop script works great! I have set it up to go to a field and tell me whether the script is on or off. To stop it I just replaced the =6 with another if statement of <=1. Thanks!!1