Formula in Bar Code

Posted on 2006-06-05
Last Modified: 2013-12-18
Is there any special rules to follow or any special characters that have to be entered if I wanted a barcode to run a formula? I am offering max points because I need a solution quickly. (I am using code 39 barcodes)
Question by:schmad01
    LVL 46

    Expert Comment

    by:Sjef Bosman
    The barcode devices I know use the keyboard input driver to get data into your system. So if you're on a text field and you scan the barcode, the data is inserted into that textfield. What is exactly your idea??

    Author Comment

    I got that. I can successfully scan text. I want to actually run a formula by scanning a barcode.
    LVL 46

    Accepted Solution

    Could you translate that into dummy-language? DO you mean something like this:
    "I want that, if the barcode reader is user, the code activates a formula"

    What operations are permitted using the barcode driver, are there any settings? Is there software available for it? What's the product and type of the reader?

    A suggestion: use a NotesTimer on the form, that looks whether there is a complete code in the field; when that's the case, use a keyboard input simulator to put an F9, Tab or Right-Arrow into the keyboard buffer. I used Ben Poole's PushKeys function to do this. See!OpenDocument

    The F9 will trigger a Recalc-event, the Right-arrow (or Tab) will trigger an Exiting-event on the field.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
    For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now