i need help with ASN in the access enviorment 1

[IGPCS]

i created a sql database where the output is ms access applications now if you know anything about edi i got to create asn so i did make the asn check number but i didnt get the barcode to print correctly i have the font and the the right scanner but i cant get the right formula to translate it into the barcode ascii code

i really like this site and the forums members they are very helpfull

thank you

IGPCS
Broolkyn, NY

 

[longhair]

IGPCS,
if you view the barcode on screen does it look correct?
what type of printer are you printing the barcode to?
regards,
longhair

 

[IGPCS]

what i meant is the barcode itself not the number the number is ok i got the correct formula and it gives me the correct check num. the problem is with the EAN font that use some other charachter that i cant figure it out how to translate it to these char.

Thanks

 

[longhair]

IGPCS,
i understand that. like i said does the barcode look correct if you view it on a report?
what type of printer are you sending it to? laserjet? intermec? zebra?
regards,
longhair?

 

[IGPCS]

i am using a regulan zebra thermal printer and yes it seems to look good but i know that its not good for the scanner dose not scan it

 

[longhair]

IGPCS,
ok then. on the right hand side of the barcode you should see 2 thin lines together. this is the marginal signal that tells the scanner what type of barcode it is (but never shows in the scanned data). i believe for upcs it is '*' and then the same at the end. try sending the data to the printer with a '*' in it. check out

http://www.barcodesinc.com/generator/barcode/

and see if the data that you enter produces the exact same barcode on the web page and on your label.
another option is to not send the font to the zebra printer but to use zpl (zebra printer language) to produce your barcode.
regards,
longhair

 

[IGPCS]

Thanks

The ASN EAN barcode is a 22 char barcode that use ascii char in it, it is used when shipping thru EDI and the "*" you talking about is for barcode 39 or only numeric barcodes but thanks anyway i appriciate your good will

 

[longhair]

IGPCS,
i understand that. thought you might be refering the the upc/ean which has to be one many customer specific labels. is your scanner set up to read the barcode? many scanners (intermec and wasp come to mind) when purchased only come set to scan code39 and code128. to scan other barcodes you have to 'turn them on'. the manual that came with your scanner should have a barcode for you to scan that will turn the function on.
can you scan other ean codes (ones that you did not create) with the scanner?
i googled and randomly checked the sites and all the samples of ucc/ean barcodes were numeric only.
regards,
longhair

 

[IGPCS]

yes thats it ean/upc and i do have the WASP scanner to read EAN and it dose read other codes i didnt create

and yes you right it uses only numbers that was my mistake but i still cant get it done i googled this for a week and couldnt find

and will give you a star for being so helpfull

 

[longhair]

IGPCS,
where did you get the font from? do they have a customer service or tech desk that you could speak to?
i, myself, do not like using fonts when sending barcode data to non laserjet printers. what we do is send the commands and data to the printer in the printers language. if you look at the zpl manual you should be able to wip up something quick - to just print a sample barcode. then try to scan that. zebra's website may already have sample code for you.
regards,
longhair

 

[IGPCS]

Longhair,

i got the font from IDAutomations and they cant help me i called them spoke for 2 hours

Thanks

 

[longhair]

IGPCS,
have you tried contacting zebra?
when sending a font to the printer you may have to pass some control codes.
regards,
longhair

 

[IGPCS]

i spoke with them 2 but they were unhelpfull but you are

thanks

 

[longhair]

IGPCS,
can you post some of your code?
are you able to create other barcodes with similar code and scan them?
can you have someone, whose EAN barcode you scan create one for you that you can scan - then create one with your program and visually compare the barcodes to see where the barcode lines do not match up?
regards,
longhair

 

[IGPCS]

well i am sorry but i cant post my code cause my partner (his name is Barry Goldstien) asked me not to post any of our codes in here and i asked about this specific and he said(shouted) NO

and yes i tried my customers EAN number with my code and it still didnt work i know the problem is with my code and not the acctual number or scanner

thnks

 

[longhair]

IGPCS,

without being able to see the code it will be difficult. but i can understand the concern with showing it.
i understand that you have tried the code with your customers EAN number. what i was suggesting was to look at both barcodes, one right on top of the other and see where the barcode lines do not exactly match. this should help give you an idea of where the issue is. by doing this you should be able to tell if the issue is with the start character(s), terminating character(s) or perhaps within the actual EAN number you are passing.
regards,
longhair

 

[IGPCS]

nice never thought about it acctually checking mycode and my customers barcode

thanks for a good idea
or i am really stupid