Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009
    Posts
    67

    Unanswered: File attched for barcode question in form

    I have table that has these fields
    [ID],[SalesDate],[ProdNumber],[SerialNumber],[EndingNumber]
    Each product has barcode number and there are two kinds of barcode one with 8 (12345678) digits and one with 9 (123456789) digits what I like to do is scan each product by barcode reader which will read the barcode as text and then I like to code as this
    8 digit barcde = 12345678 the first three digits are the [ProdNumber] and digit 4 and 5 are [SerialNumber] and the last three as [EndingNumber].
    9 digit barcode = 123456789 the first four digits are the [ProdNumber] and digit 5 and 6 are [SerialNumber] and the last three as [EndingNumber].
    Also I designed form for data entry which has all the fields in the table and unbound field for barcode reader. I dont want to store the barcode reader (Im not sure if I should) but I want to scan each item and then separate the barcode as above. I attached file here.
    Thanks
    Attached Files Attached Files

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    So.....

    What's the question?

    Would make much more sense to have one barcode per product of course.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •