Remove 1 from stock with everu barcode scan

Discussion in 'Access General' started by Hollsten, Apr 1, 2014.

  1. Hollsten

    Hollsten Guest

    hello, how can I make this happend?

    In a modal popup window users reads a product code with a barcode scanner and every time they do this the particular product's stock is reduced by 1 in the database.

    Any help would be highly appreciated.

    J.H.
     
    Hollsten, Apr 1, 2014
    #1
    1. Advertisements

  2. Hollsten

    TallyV Guest

    First, configure your scanner to add a TAB or Enter to each scan. Then add an After Update event that calls a function to lookup the scanned part and appends a transaction record to reduce you on hand qty.
     
    TallyV, Apr 5, 2014
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.