Newbies rdehart Posted July 12, 2000 Newbies Posted July 12, 2000 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?
yafreax Posted July 14, 2000 Posted July 14, 2000 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.
ZuperZZ Posted July 14, 2000 Posted July 14, 2000 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
Newbies rdehart Posted July 14, 2000 Author Newbies Posted July 14, 2000 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
Recommended Posts
This topic is 8883 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now