Results 1 to 4 of 4
  1. #1
    kamathmanoj is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    May 2019
    Posts
    41

    Unhappy Data Matrix Bar Code - Different Types Resulting in Different Output

    Hi Everyone,

    I am new to Access but even newer to Data Matrix Bar Codes. I have designed a simple form to try and simplify my question here. I have 2 similar data matrix bar codes. Both are created using different software. When I scan them using a Symbol MC32N0 scanner, to Notepad - they enter the exact same data. I tried scanning to Word 2016, they are the exact same. Each line has a "carriage return" and a "page break". However they behave very differently in MS Access. One code enters all the data into a single large text box and I can draw the data into an array for manipulation. The other one, puts each line into a different text box (or tries to) and if there is data in the text box, it replaces with a new data line every time. I have tried to show what happens below with a form that has no code across 3 text boxes.

    Click image for larger version. 

Name:	Data Matrix Bar Code (Zint).png 
Views:	14 
Size:	12.0 KB 
ID:	39323 Click image for larger version. 

Name:	Data Matrix Bar Code (Program).png 
Views:	14 
Size:	5.9 KB 
ID:	39324

    Please help me understand what might be different as they show exactly the same in Notepad and in MS Word.



    Regards,
    Manoj

  2. #2
    kamathmanoj is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    May 2019
    Posts
    41
    Notepad data:
    (P)C22J148AA


    (V)SDI


    (S)1602552202


    (K)378159


    (1T)B904863


    (2Q)31700


    (1Q)1025


    (Q)1


    (ZC).06


    (ZMN).53


    (ZP).012


    (ZS).004


    (ZSI).01


    (ZAL).022


    (T)70.1


    (Y)55.4


    (E1)32


    (W)56.5700


    (G).1570

  3. #3
    kamathmanoj is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    May 2019
    Posts
    41
    Each field appears on its own page in Word like this:

    Click image for larger version. 

Name:	Data Matrix Bar Code (Word).png 
Views:	13 
Size:	1.9 KB 
ID:	39325

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    In the first image, why is third item different in third box - last 2 digits are transposed.

    As I understand scanners and interaction with Access, they can be set to automatically leave textbox OR to continue on new line in same textbox depending on characters at end of code string. Usually an Enter character so focus will leave textbox and commit the input. I expect the two software are formatting codes differently.
    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.

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

Similar Threads

  1. Why is this code resulting in an update?
    By scott0_1 in forum Programming
    Replies: 1
    Last Post: 06-29-2018, 11:34 AM
  2. Replies: 2
    Last Post: 08-15-2016, 02:47 PM
  3. DB Design starting first model , with Matrix data from Excel
    By warlock916 in forum Database Design
    Replies: 6
    Last Post: 01-11-2016, 01:47 AM
  4. vba code for To calculate the inverse matrix
    By Milade8080 in forum Modules
    Replies: 1
    Last Post: 03-11-2014, 06:10 AM
  5. Replies: 6
    Last Post: 06-25-2012, 02:57 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