New User? Sign Up  |  Sign In  |  Help
Barcode support and
tutorials from IDAutomation
and the community.
Click for the BBB Business Review of this Computers Hardware, Software & Services in Tampa FL
Resolved Questions Bookmark and Share
mmonk

IMB Container Barcode with Access VBA

I am trying to use the CODE 128 font in Access to produce an IMB Container Barcode.
The VBA module does not include a specific GS1-128 function, but the instructions seem to indicate to use the Code128 function with the apply tilde set to true. I have tried this and the barcode will not come out to USPS specifications. The post office has rejected them and I can't get it to match what is coming out of our other canned software program.
I am trying to encode a barcode like this: (99)M107293000000029583.
Which function should I use in the VBA for Access module to produce the GS1-128 barcode?

Operating System: Windows XP

Application: MS Access97

01-29-15     1774 day(s) ago    

  Report Abuse

 

mmonk

Best Answer

I agree, the Auto Encoding solution in the VBA module is more efficient and is technically correct. Unfortunately, the post office has an issue with it and my task is to duplicate the barcode from the other software.
I have made a new Access function that uses the Start B character and adds a Chr(202) as the FNC1 in front of my barcode value and it seems to match up with my target barcode, bar-for-bar. I have sent it in for them to approve. Hopefully that is the end.
Your responses and your Code 128 FAQ were a great help, thanks.

Posted 1773 day(s) ago

()
()
  Report Abuse
 
Find Interesting
 
Email to Others
 
Bookmark
 
Subscribe to Answer Alert
No comments yet.     Be the first to comment.
Other Answers (5)

Ben
Correct. This is why IDAutomation has made a solution that is more efficient (and follows the specification)-- it uses Auto encoding which is a subset that switches between Code A, B, and C. The solution uses a start C, then switches to B. Technically, the solution is not incorrect. However, it looks as if the USPS locations that you are using did not take into account the Auto encoding which our component does.

Posted 1773 day(s) ago

()
()
   Report Abuse

mmonk
In the document you linked to, section 3.3.1 states:
"Only subsets B and C are permitted for this application. "
"Note: Subset C allows for more efficient encoding of numeric values (i.e. can shorten the
overall barcode length) than Subset B; however, Subset C does not support encodation of alpha
characters. Subset B allows for encoding of numeric values and also supports the encoding of
both “upper” and “lower” case alpha characters. Special shift characters must be used to toggle
between subsets."

Because my barcode value includes an alpha character, shouldn't the VBA module either use subset B or use Start C and toggle into subset B to encode the alpha character?

https://ribbs.usps.gov/intelligentmail_container_barcode/documents/tech_guides/IM_CONTAINER_BARCODE_SPECIFICATIONS_%28SPUSPS-B-3215B001%29.pdf,

Posted 1773 day(s) ago

()
()
   Report Abuse

Ben
GS1-128 is a standard of the Code 128 symbology. Therefore, technically any scanner that can scan GS1-128 should be able to scan Code 128. However, I am not going to rule out some special settings. IDAutomation bases its encoders and components on the IM Container Code by the USPS which uses a Start C. Based on this specification, the barcode created with our product is correct. If there is a new specification, that requires a Start B (the start character in your previous Container barcode), please sent to support@idautomation.com.




Posted 1774 day(s) ago

()
()
   Report Abuse

mmonk
The post Office can scan if they use a scanner calibrated for CODE 128, but not if they use a scanner that only reads GS1-128. The samller post offices can only read GS1-128 and are rejecting our barcodes.
It's not the size, it's the bar structure.
Here's a rejected code from the Access report:
image

Here's a good code from our other software program:
image

Posted 1774 day(s) ago

()
()
   Report Abuse

Ben
1. Can you provide information about why the Code 128 barcode is rejected?
2. Can you attach a screen shot to the post?
3. When you mention the barcode does not match, is it the size or the bar structure?

I will need a bit more information to provide a possible solution to the problem.

Thanks.



Posted 1774 day(s) ago

()
()
   Report Abuse
Email this question link to friends
You must enter an email address, if name is entered or vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allows to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must starts with "http://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always starts with " http:// ")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 Characters are allowed. Current Count: 0
  Your comment on this answer
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allow you to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must start with "http://" or "https://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always start with "http://" or "https://")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 characters are allowed. Current Count: 0

You may answer and comment on any thread according to the Terms and Conditions.

 © Copyright 2019 IDAutomation.com, Inc., All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us
Training Videos on YouTube Join us on Google Plus Join us on LinkedIn Follow us on Twitter Like us on Facebook