Results 1 to 5 of 5
  1. #1
    BigJohn89 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Dec 2017
    Posts
    37

    Barcode scanner and click event

    Hello



    Is there a posibility to create click event by using barcodes scanner? Users are using database with connected scanner.
    E.g. there are 4 different barcodes next to the tablet with database. Each of them respons for another button in form.

  2. #2
    Minty is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,002
    The barcode effectively simply enters text, so if you scanned the results into a textbox and used the after update event to check what had been entered, you could then process the result to run whatever code you wanted?
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    BigJohn89 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Dec 2017
    Posts
    37
    What in case when I have 3 textboxes that need to be fill by using scanner at first?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,892
    Move into textbox, use scanner to enter data. However, doubt this alone will trigger event, probably have to press Enter.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Minty is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,002
    You can program most barcode scanners to send an "Enter" keycode after a successful scan.
    So in theory just do the each scan then move to the next text box, then in the third After_Update event run your checking code.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Barcode Scanner Invalid Scan
    By nick243 in forum Access
    Replies: 2
    Last Post: 06-13-2016, 02:09 PM
  2. How can a barcode scanner autofill fields
    By Business in forum Programming
    Replies: 5
    Last Post: 05-26-2016, 11:01 AM
  3. Barcode scanner
    By Business in forum Programming
    Replies: 1
    Last Post: 05-22-2016, 08:48 AM
  4. Replies: 3
    Last Post: 12-14-2014, 01:20 PM
  5. Barcode scanner for small project
    By miziri in forum Programming
    Replies: 7
    Last Post: 05-20-2011, 01:50 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums