Results 1 to 3 of 3
  1. #1
    5275275 is offline Novice
    Windows 8 Access 2007
    Join Date
    Jan 2015
    Posts
    2

    Barcodes are being read/entered backwards! Barcode string is reversed when scanned into lookup field

    I'm on a Windows 8.1 machine running Access 2007 full version.

    I have limited knowledge of VB but I understand a fair amount of Access. My POS program has two different forms that have fields which I scan barcodes into. As far as I can tell the settings are the same for these fields. I use code 39 barcodes and Honeywell/Metrologic scanners. On one of my forms the barcodes scan in just fine, the "enter" command is automatically sent after the string is read and everything works great, the items are found in my database and their info loads correctly. On the problematic form I scan the same barcodes but the barcodes are displayed in reverse, hence the items are not found. The entire string of numbers and/or letters is backwards. I've tried several different barcode scanners. I could be wrong but I believe that the "enter" command is even sent first before the barcode actually entered into the field because I get a pop-up stating that the item is not found before the barcode string appears in the field. After I click OK on the pop up the barcode string appears in the field with the digits in reverse order.
    Does anyone have any idea what might be causing this?

    On a somewhat related note:
    On a different computer, also running Access 2007 full version and Windows 8.1, when I scan barcodes into the same problematic form the barcode string get jumbled around slightly. It appears that some numbers in the barcode string are not being read, their order is being switched and/or the "enter" command is sent mid-read (e.g. the first 3 numbers are read and appear in the field, then the "enter" command is sent, then I get the pop up and click OK, then the remaining 9 numbers are read and appear in the field).

    I would occasionally get a jumbled barcode string when using Windows XP or 7 but very rarely. With Windows 8.1 it's happening every time on the problematic screen.

    Thanks in advance for any ideas or assistance!!!

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    May not be worth much........

    The entire string of numbers and/or letters is backwards. I've tried several different barcode scanners. I could be wrong but I believe that the "enter" command is even sent first before the barcode actually entered into the field because I get a pop-up stating that the item is not found before the barcode string appears in the field. After I click OK on the pop up the barcode string appears in the field with the digits in reverse order.
    Does anyone have any idea what might be causing this?
    This sounds like the text box "Reading Order" property might have been changed. Should be "Context" or "Left to Right".


    I would occasionally get a jumbled barcode string when using Windows XP or 7 but very rarely. With Windows 8.1 it's happening every time on the problematic screen.
    Do you do a "Compact and Repair" regularly? There is a (small) chance this could be caused by corruption. Did you try a different dB (New/ test) to see if the same behavior happens?

  3. #3
    5275275 is offline Novice
    Windows 8 Access 2007
    Join Date
    Jan 2015
    Posts
    2
    Quote Originally Posted by ssanfu View Post
    May not be worth much........


    This sounds like the text box "Reading Order" property might have been changed. Should be "Context" or "Left to Right".

    I tried "Context" and "Left to Right"; they yield the same results. I then tried "Right to Left" and oddly enough it works, most of the time. Sometimes the digits get jumbled and are out of place in the barcode string still. I cannot imagine why this would work but thanks for the tip. Now the question is, why do they get jumbled sometimes?

    Do you do a "Compact and Repair" regularly? There is a (small) chance this could be caused by corruption. Did you try a different dB (New/ test) to see if the same behavior happens?
    I have it set to compact when closed, which is almost every day. I tried a different db and got the same results.



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

Similar Threads

  1. Replies: 1
    Last Post: 12-07-2014, 12:33 PM
  2. Replies: 2
    Last Post: 10-29-2014, 10:48 AM
  3. Replies: 97
    Last Post: 05-24-2012, 02:10 AM
  4. Forms Populating Backwards
    By kbrown in forum Forms
    Replies: 0
    Last Post: 06-21-2011, 09:47 AM
  5. Replies: 3
    Last Post: 08-08-2010, 01:10 PM

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