Results 1 to 3 of 3
  1. #1
    badmem is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2016
    Posts
    24

    Question Add records to a table one by one without using RUN

    I want to add records to a table one by one using barcodes. I don't want to click run after I scan each barcode. I want to scan a barcode which gets stored in a table. The database then waits for the next barcode and enters that into the next row - until all of the items have been scanned.



    How can I do this?

    Thank you.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    at the end of the scan, youd run a saveRecord, then add new record.
    BUT if you scan the last barcode then youre stuck with a new record that is blank.
    if you use Autonum, then you get a blank record with an unused ID.
    so
    if you can edit the Scan event, it would be:
    ..scan
    ..add new record
    ..fill barcode
    ..save record

    But Im not sure how your barcode scan event works.

  3. #3
    badmem is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Mar 2016
    Posts
    24
    Thanks for the reply ranman. How do I run a saveRecord and add new record?

    Sorry for the basic question.

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

Similar Threads

  1. Replies: 83
    Last Post: 11-29-2016, 09:38 AM
  2. Replies: 1
    Last Post: 12-20-2015, 01:09 PM
  3. Replies: 1
    Last Post: 10-07-2015, 11:33 AM
  4. Replies: 4
    Last Post: 07-14-2015, 06:49 PM
  5. Replies: 1
    Last Post: 02-16-2013, 11:36 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