Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 8883 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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?

Posted

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.

Posted

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 laugh.gif

  • Newbies
Posted

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.