EAN - PrecisionID.com
Contents
1. TET j satai d Ee ak fala T a Page Header Layout View 1 Design View Rime ibe boitsseeeeteteeeey Print Preview WE Matail Add a Textbox to the report This text box will be modified to contain a barcode Select the textbox and if the properties window is not visible Right click on the text box and choose properties Place the formula PrecisionID_UPC_A Field1 for Access 2010 or PrecisionID_UPC_A Table1 Field1 for Access 2007 in the control source property of the text box where Tablel is the table and Field1 is the field that contains the data to be encoded into the UPC or EAN barcode You may also use the formulas PrecisionID_UPC_EC PrecisionID_EAN8 or PrecisionID_EAN13 for the other UPC EAN barcode types Change back to Report View by right clicking the report s tab and selecting Report View You should see that the formula changed the data from the database and appended additional characters at the beginning and ending of the text You may notice that the numbers from the data are a Save z GE Close F Tal Ga Close All G BepotView ro i Layout View 3 iT Z Design View 417 fet Print Preview 7 ITESTCBXBI Switch back to the report in Design View select the text box and choose one of the PrecisionID fonts such as PrecisionID EANUPC T09 and choose 18 for the point size of the font You must select the appropriate font for the formula you are using Size the text bo2. PrecisioniD UPC and EAN Barcode Fonts User Manual 1 TA 2 Updated September 2010 Copyright 2010 Precisio LLC PrecisionID EAN amp UPC Barcode Font User Manual Notice When you use this product you agree to the End User License Agreement EULA The EULA is provided as a file in the package for this product To view the license online please visit www PrecisionID com licenses Limitations of the demo version The demo version of this product may be used for evaluation purposes only In the demo version some of the bars in the bar code contain the demo watermark All other characters and symbols are exactly the same as the purchased version If you are using the demo version and you would like to order please visit http www precisionid com EAN amp UPC Symbolo 0 1 arate ct pastes chaem acon nee vad n EE ances E E e E S l Product OVEN ION eroriren E E E E T E A E E E A 2 MVS CA ae ccs ET E E E E E A ence E E E E E E E E E T 2 D OSOE WV AO E E E E dosadabusdenstgnubaoceadacmnenend 2 harean O e D E E A E E E E E E A EEEE 2 Other Oporna S y e NG e E E en sawcbenlorsauunaca corsacwens 2 Wisi Tie Fontsto Create Bar C Odes senseca e O E E E e 2 Tuori Tor Specie ADPIC ANONS cresu EEE ER NE 2 MAOO ZAC CCS 8 A E E E E E tecretaanecnseederoreseee 2 Ni O OR ER a a A E E E E E 3 IVINCEOSOIE Vy ORG NENTE a E E E EN 4 CY SEAN TR CDOS eE S E E E 4 P O e E E E EE E E E E A T E E A EE A 3 Font Point Sizes and Magnification Factor ecisic
3. EANUPC T12 font Make the font 20 points in size Crystal Reports This example was created in Crystal Reports version 8 Implementation in other versions of Crystal Reports is very similar if not identical The fonts and UFL are compatible with Crystal version 7 and above 1 Open your Crystal Report and switch to design mode In version 8 choose Insert Formula Field or in version 9 and above choose Report Formula Workshop 2 Right Click on Formula Fields and choose New 7 Close O amp Ii Hide 3 Give your formula field a name in this example we will name it PrecisionID_Barcodel In versions 9 and above if you are asked to use the editor or the expert choose Use Editor 4 Inthe Formula Editor choose Functions Additional Functions and select the PrecisionID_UPC_AQ function or to create another barcode type choose the correct function from Fig 1 The U25PrecisionID dll UFL file must be installed before you can use this formula or you will receive an error This UFL file is installed by running the Setup exe file in the font package The U25PrecisionID dll file is also provided in the Crystal DLL folder of the Zip file To manually install it copy it to the Windows System directory or the directory where the Crystal DLLs are located When the U25PrecisionID dll file is installed and active the PrecisionID formulas will appear in the Formula Workshop under Additional Functions 5 Place the cursor b
4. another barcode type choose the correct function from Fig 1 in the control source property of the text box where Tablel is the table and Field1 is the field that contains the data you want to barcode Run the report You should see that the numbers from the data are converted into other characters this is normal and indicates the product is working properly V b23456 RSTKLm W Open a report in design view select the text box and choose one of the PrecisionID fonts such as PrecisionID EANUPC T12 and choose 20 for the point size of the font You must select the appropriate font for the formula you are using For example if you have a formula for the EAN or UPC barcode you must select the EANUPC Font Size the text box so it is large enough to contain the entire barcode You will need to adjust both the height and width Be sure to leave some extra space to the right and left of the barcode on the report Generally you need about 3 times the space to the left and right of the barcode as the thickest bar in the bar code 10 Save and run your report You should see the barcode appear in the text box Microsoft Excel 2000 l 10 11 NOTE the PrecisionID EANUPC T09 font is formatted specifically for use in Microsoft Excel Other fonts may work but may not format properly in the cells In this example we will create a barcode in cell B10 using the data from cell A10 for the barcode Extract the PrecisionID_EANUPC_Module bas file from the
5. as Binary PFB and ASCII PFA versions of PostScript fonts Consult the documentation for your operating system about instructions and which font to install Using the Fonts to Create Bar Codes When creating barcodes with our fonts we recommend using the PrecisionID Font Formatting Components which automatically perform the required calculations and simply return the text that is formatted to the barcode font When this text 1s printed with our barcode font a correct barcode 1s created To calculate the check digit manually we suggest following the Visual Basic source code we provide This code is located in the Examples VB Module folder of the package Tutorials for Specific Applications The results for the following tutorials are saved in the examples folder of the product zip file We encourage you to refer to the examples provided in this folder Microsoft Office 2010 and Office 2007 Examples The results for the following tutorials are saved in the examples folder of the product zip file or the product installation directory Refer to the examples provided in this folder for quick and accurate implementation of your PrecisionID barcode Microsoft Excel 2010 and Excel 2007 l oo NOTE the PrecisionID EANUPC T09 font is formatted specifically for use in Microsoft Excel Other fonts may work but may not format properly in the cells In this example we will create a barcode in cell B8 using the data from cell A8 for the ba
6. variety of barcode generation software Visit www PrecisionID com for more information on these products Code 128 Barcode Fonts Generate Code 128 UCC 128 EAN 128 and USS128 Barcodes easily using this package Code 39 Barcode Fonts Generate Code 39 Code 3 of 9 LOGMARS and HIBC Barcodes easily using this package Interleaved 2 of 5 Barcode Fonts Generate USS Interleaved 2 of 5 EAN 14 ITF 14 German Post Identcode and Leitcode Barcodes easily using this package UPC Barcode Fonts Generate UPC A UPC E UCC 12 EAN 8 EAN 13 ISBN Bookland and JAN barcodes using this package EAN Barcode Fonts Generate EAN EAN 13 EAN 8 UPC A UPC E UCC 12 ISBN Bookland and JAN barcodes using this package POSTNET Barcode Fonts Generate USPS POSTNET Planet and FIM barcodes using this package Native ASP Barcode Generator Generate most common barcodes on any website utilizing this ASP barcode generator Barcode ActiveX Control Generate most common barcodes in ActiveX graphics object compatible environments using this ActiveX control Data Matrix Barcode ActiveX Control Generate Data Matrix ECC200 PDF417 and Macro PDF417 barcodes in any ActiveX graphics objects compatible environment using this ActiveX control PDF417 Barcode ActiveX Control Generate PDF417 Macro PDF417 and Data Matrix ECC200 barcodes in any ActiveX graphics objects compatible environment using this ActiveX control OCR A and OCR
7. B Fonts Create bank checks passports credit card imprints serial labels postal mail and more with this OCR A and OCR B font package MICR E13B Fonts Create bank checks and other paper based drafting documents using this MICR E13B Font Package 17
8. C Font After selecting the bar code font you should see the barcode appear Size the width of the column so that there is some white space before and after the bars of the barcode To create an entire column of barcodes choose Edit Copy with cell B10 selected Highlight cells you wish to add barcodes to and choose Edit Paste The formula will automatically adjust for the other cells Microsoft Word 2000 Mail Merge 1 Open the mail merge document 2 To create a barcode in a Word mail merge we must insert a merge field from a data source that already formatted the text to the barcode font In this example we use Excel as the data source The Excel spreadsheet data source must already be setup with barcodes just like the Excel Tutorial in this document 3 In Word Choose Tools Letters and Mailings Mail Merge and select the Excel spreadsheet for your data source Be sure to select the columns and range for the cells that contain the data formatted to the barcode font You may have to go through the Word mail merge tutorial for assistance if you are unsure of how to connect to a data source or perform a mail merge 4 When connected to the data source we insert the merge field of lt FormattedText gt into the document When we choose the View Merged Data option we see the text formatted to the barcode font from the data source appear V b23456 RSTKLm W 5 Select the text in the merged data and choose the PrecisionID
9. canddevesosaweimcavencvensiawerecne Mcveusiawehacndencveasianenedne Ueveeviancvacnteate 2 Font Names and Bar Code Height csgcccce ccasnescntonuacotuasiotensacausueosteseactssadentnneatiodeatimenseeacteawedaioduacneuptodeetameesacoene 6 EAN amp UPC Symbology Overview The EAN amp UPC Font Package is designed to print only UCC 12 UPC A UPC E EAN 8 and EAN 13 barcode types UPC A is also referred to as UCC 12 Any other type of UCC or EAN barcode is usually created with the Code 128 Fonts EAN amp UPC barcodes can only encode numbers of certain lengths according to the chart in Fig 1 below For UPC A and EAN 13 an optional add on barcode can also encode 2 or 5 more characters To encode the add on in the barcode simply append this number to the end of the primary number Fig 1 data lengths for EAN amp UPC Barcode Types Barcode type Length of digits to create Function to use in VBA PrecisionID_EAN 8 PrecisionID_EAN13 PrecisionID_UPC_A PrecisionID_UPC_E UPC E is a compressed version of UPC A therefore all 11 or 12 digits of the UPC A are necessary to perform the compression Product Overview Print Requirements To create a correctly sized barcode with the EANUPC fonts they need to be printed between 18 and 36 points 20 points is recommended These fonts also need to be printed on a printer with 300 dpi or greater resolution EAN amp UPC is a more complex bar code type because it requires a check digit calculation and
10. etween the parentheses in the formula and select the field you wish to encode in the barcode from the Report Fields area in the Formula Editor A correct formula will appear something like PrecisionID_UPC_A Table1 Field1 where Table1 Field1 is the table and field of your database 1j Formula Editor PrecisionID_Barcode1 xf oE Tablet x PrecisionID_PNET string Aj c D Ki PrecisionID_UCC128 string Field1 PrecisionID_UPC_A string 4 gt PrecisionID_UPC_E string PrecisionID_UPC_A Tablel Field1 6 The tables and fields should be visible above in your database connection Choose Save and Close 7 From the Field Explorer drag the PrecisionID_Barcodel Formula Field to the report 8 Choose File Print Preview You should see that the formula field formatted the data from the database and appended additional characters at the beginning and ending of the text You may notice that the numbers from the data are converted into other characters this is normal when you are using EAN amp UPC Fonts iV b23456 RSTKLm W 1 9 Select the ann field asd o the PrecisioniD EANUPC T12 font Set the point size to 18 points or greater we recommend 20 points You must select the appropriate font for the formula you are using 10 Size the formula field so it is large enough to contain the entire barcode You will need to adjust both the height and width Be sure to leave some extra space to the right and left of the barcode o
11. i Toolbar on selection G Enable Live Preview t Advanced v Show Developer tab inthe Ribbon G Customize Always use Clearlype 10 Select the Developer Tab and click the Visual Basic Icon Ma a SoHo _ Home Insert Page Layout Formulas Data Review View Develo Pd Record Macro Sa SF Properties B Prope SS id Use Relative References N Qel View Code Expansion F Macros insert Design l i i d Macro security Mod a Run Dialog Source ay Code Controls XML 11 12 13 14 15 16 17 Choose File Import File and navigate to the PrecistonID_EANUPC_Module bas file located in the Program Files PrecistonID EANUPC Font Package folder After this module is imported it will be visible in the list of modules Choose File Close and return to Excel a Microsoft Visual Basic Booki File Edit View Insert Format Debug Rui i Gel Save Booki Ctri S cm i Import File Ctl M Export File Ctri E E du Print Ctrl P XX Close and Return to Microsoft Excel Alt Q In cell B8 enter the formula PrecisionID_UPC_A A8 which is required to format the data to the font You may also use PrecisionID_UPC_E PrecisionID_EAN8 or PrecisionID_EAN13 for the other types of EAN and UPC barcodes Notice that the formula changed the data from cell A8 and appended additional characters at the beginning and ending of the text Also notice
12. n the report Generally you need about 3 times the space to the left and right of the barcode as the thickest bar in the barcode a ka dd rd ee ed f ae FEPFF b34 56l il hy ae ae Ce ar al ad a a ak ik it at a a ea a 11 The barcode should now be visible when you run your report i EL Soe eee TETTEIT Specifications Font Point Sizes and Magnification Factor These fonts need to be printed on a printer with 300 dpi or greater resolution at a magnification factor of 80 to 200 to meet UPC and EAN requirements Because 22 points is a magnification factor of exactly 1 the point size you choose should be between 18 to 36 points Try using 20 points first if it is possible because at 20 points the symbol is best reproduced on 300 dpi printers Font Names and Bar Code Height The numbers at the end of the font name is to identify the height of the font in millimeters mm when printed at 20 points Specifications developed in the 1970s call for a height of 22 mm however with modern scanners the barcode can still be read with font heights as short at 9 mm Font Name Approximate Font Height at 20 points PrecisionID EANUPC T09 09 mm use in Excel PrecisionID EANUPC T12 12 mm PrecisionID EANUPC T15 15 mm PrecisionID EANUPC T18 18 mm PrecisionID EANUPC T22 22 mm Use for UPC A and EAN 13 Copyright 2010 PrecisionID com PrecisionID Barcode Products PrecisionID offers a
13. nt to create AAN 8 Bes gt Se ome sert Page Layout References aoe Envelopes Labels Start Mail Select t Merge Recipients t List M Create rs o E Mail Messages Envelopes Labels Directory Honmal Word Document ti me amp Click Select Recipients and select Use Existing List Navigate to the spreadsheet with the barcode data Finally select the Worksheet within the Workbook with the data 1 e sheet1 Pa duaa insert Page Layout References Mailing FANG Step by Step Mail Merge Wizard Envelopes Labels Start Mail Selec Merge Recipients 7 Recipient List Merge Field Create lie Type New List O Usg Basting liste ka Select from Outlook Contacts Place the cursor at the location for the barcode and click Insert Merge Field and select the information to be inserted 1 e FormattedText Pin j m u io re c3 es Home Insert Page Layout References Mailings Review View Developer al i COS C j hy R l r i Ee aA 3 2 Rules _ 4 __ 13 Match Fi Envelopes Labels Start Mail Select Edit Highlight Address Greeting Insert Merge Merge Recipients Recipient List Merge Fields Block Line Update Create Start Mail Merge Write amp In Data If you click Preview Results the text formatted for the barcode from the data source appears B a his oO fot a Ge Documenti Microsoft Vi Home Insert Page Layo
14. other number pairing functions Our PrecisionID Font Formatting Components are provided with this package to simplify this process and make printing barcodes with our fonts an easy task The PrecisionID Font Formatting Components include a Crystal Reports UFL Microsoft VBA module for Excel and Access and Visual Basic source code which may also be used as a guide for conversion to other languages This package also provides working examples for Word Access Excel and Crystal Reports Installation Microsoft Windows Decompress the fonts in the supplied ZIP file with a decompression utility such as Winzip Our fonts are compatible with all 32 bit versions of Windows We recommend using the supplied Setup exe file to install the fonts automatically in Windows If you wish to manually install the fonts in Windows open Control Panel and choose Fonts then choose Install New Font and browse to the folder that contains the fonts with the TTF extension you extracted from the zip file Macintosh OS X Our fonts are compatible with all versions of Macintosh OS Version 10 1 and greater OSX Decompress the fonts in the supplied ZIP file with a decompression utility such as Stuffit Expander Drag the files with the TTF extension to the Library Fonts folder of your hard drive To activate the fonts restart the application some applications may require a restart of the computer Other Operating Systems We supply Windows TrueType TTF fonts as well
15. package and place it in the My Documents folder Before we can create barcodes in Excel we must import the required module and change the security setting so it will run In Excel choose Tools Macro Security and set the security level to Medium Choose Tools Macro Visual Basic Editor Data Window Help Security hook File taper File and select the PrecisionID_EANUPC_Module bas file from the list of files After this module is imported it will be visible 1n the list of modules Choose File Close and return to Excel In cell B10 enter the formula of PrecisionID_UPC_A A8 or to create another barcode type choose the correct function from Fig 1 which is required to format the data to the font You should notice that the formula changed the data from the spreadsheet and appended additional characters at the beginning and ending of the text You may notice that numbers from the data are compressed into other characters this is normal when creating EAN amp UPC barcodes With cell B10 selected choose the PrecistonID EANUPC TO9 font which is specifically formatted for use in Microsoft Excel and choose 18 or greater for the point size We also recommend centering the text in this cell so the barcode will contain white space before and after the barcode You must select the appropriate font for the formula you are using For example if you have a formula for the EAN amp UPC barcode you must use the EANUP
16. rcode Extract the PrecisionID_C128_Module bas file from the package and place it in a folder of your choice Before creating Code 128 barcodes in Excel 2010 or 2007 you must enable the Developer Menu to import the required module so it will run If you already see the Developers Tab you may skip to Step 10 Excel 2010 Select the File Tab and then Options from list in the left column Excel 2010 In the Excel Options window select Customize Ribbon Excel 2010 In the right half of the window check the Developer check box and click OK Excel 2007 Click the Office Button and select Excel Options at the bottom Ez a ea Rew i 1 Motor Calti a E a Open 3 Price Litt 2008 len 3 ASML alesse d Pulley Cales xisx i ave i 5 Minibot Speciats sti re G Minibot Price List oti soim i FNI Save ij Wag i MELSFLOHI BOM 1 fam B Hims BOM xiti O Print w 5 9 Price List 2008 v3 nim i P TRA INVENTORY ator Tal Prepare Work Sheet for priesais ie Abbott BOMs atex i E a seng i Dataset 50 mMmrentit Dataset S lsecte get Publish F T Race Quick Pricing Taglie k Webste Database intealee i Close Quote Spreadshectalsa cDeEseet Options X Eat Excel Excel 2007 In the Popular Options check the Show Developer Tab in the Ribbon Click OK Excel Options oy Popular B Change the most popular options in Excel Formulas Proofing Top options for working with Excel Save Show Min
17. that numbers from the data maybe compressed into other characters this is normal when creating UPC or EAN barcodes With cell B8 selected choose the PrecisitonID EANUPC TO9 font which is specifically formatted for use in Microsoft Excel and choose 18 or greater for the point size We also recommend centering the text in this cell so the barcode will contain white space before and after the barcode You must select the appropriate font for the formula you are using For example if you have a formula for the EAN amp UPC barcode you must use the EANUPC Font After selecting the bar code font the barcode will appear Size the width of the column so that there is some white space before and after the bars of the barcode To create an entire column of barcodes choose Edit Copy with cell B8 selected Highlight cells you wish to add barcodes to in column B and choose Edit Paste The formula will automatically adjust for the other cells Microsoft Word 2010 and Word 2007 Mail Merge l 2 Open the mail merge document To create a barcode in a Word 2010 or 2007 mail merge we must insert a merge field from a data source that has already formatted the text for the barcode font In this example we use Excel as the data source The Excel spreadsheet data source must already be setup with barcodes just like the Excel Tutorial in this document In Word 2007 select the Mailings menu item click Start Mail Merge and select the type of docume
18. ut Menu from Macrc Objet Dependencies Relationships a n Ne if F j Macro 6 Select File Import File and navigate to the PrecisionID_C128_Module bas which is located in the Program Files eee sion EANUPC Font Package folder After it is properly imported it will appear as one of the modules in the database 4 Microsoft Visual Basic Code 178 Access 2007 Exa ile Edit View Insert Debug Run Tools Add In li Save Code 128 Access 2007 Example Ctri S Close and Return to Microsoft Office Access Alt Q 7 aa Microsoft Visual Basic Code 1 6 Access 200 7 Exa Edit View Insert Debug Run Tools Add u Save Code 128 Access 2007 Example Ctri S Pi Import File Ctri Mi ey Print Ctri P P lt Slose and Return to Microsoft Office Access Alt Q 8 Select File Close to return to Microsoft Access 2010 2007 9 Create a Suu by selecting Create Report in the Ribbon 1 Pa E 5 Table Tools Code 128 Access 2007 Example Di Home Create External Data Database Tools Datasheet zE PE T e T ij PivotChart kS m j Labels a i E Blank Form LJ Blank Report Table Table SharePoint Table Form Split Multiple Report eport Templates Lists Design Form tems a More Forms Daig st Report Wizard kie Tables Forms Reports 11 12 13 14 15 16 save Close 1 Close All Report View el SR Te Yr oe j a s Report Headi H a TTO C DE J 1
19. ut References Mailings Review View Developer J Fe A ict aA 24 B 2 Rules teh H din i g amp m 13 Match Fields Ej Find Re Envelopes labels Start Mail Select Edit Highlight Address Greeting Insert Merge Preview Merge Recipients Recipient List Merge Fields Block Line Field gt pdate Lab Results ay Auto Ch Create Start Mail Merge Write amp Insert Fields Preview Res Text formatted to barcode font ITESTAC BCI Select the text in the merged data and choose the PrecisionID EANUPC T09 font Make the font 18 points in size For additional help see Word 2007 Help or use the Mail Merge Wizard under Mailings Start Mail Merge Microsoft Access 2010 and Access 2007 To create a UPC or EAN barcode in a Microsoft Access report 1 Run the Setup program to install the barcode fonts VB Module and Access Example file 2 Create a new blank database Access 2010 Select the File tab and double click New Database or Access 2007 Click the Office Button select New name the file and click Create 3 Enter some data into a new field This data will be encoded into a barcode Add New Field 3 TEST1234 4 TEST2345 4 Save the database 5 Before creating barcodes in Microsoft Access you must import the required module Select Database Tools and click the Visual Basic button 22 we O amp a Table Tools 3 Home Create External Data Database Tools Datasheet Gy Run Macro aS f Property Sheet Create Shortc
20. x so it is large enough to contain the entire barcode You will need to adjust both the height and width Be sure to leave some extra space to the right and left of the barcode in the report Generally the space should be about 3 times wider than the thickest bar in the barcode Table1 ID gt LINDA NOON MDT CONUN UN UODUTII ETI T 7 WIDOT IT AIIM 3 Page lofi Microsoft Office 2000 Examples The following tutorials are saved in the examples folder of the product zip file or in the installation directory Refer to the examples provided in this folder for quick and accurate implementation of your PrecisionID barcode Microsoft Access 2000 To create a barcode in a Microsoft Access report I 2 a Run the Setup program to install the fonts and Access Example file Before we can create barcodes in Access we must import the required module Choose Modules Import and select the Access Example mdb file which will be located in the Program Files Precision ID EANUPC Font Package folder Choose the module to import from the other database this module should be named PrecisionID_ EANUPC_Module After it is properly imported it will appear as one of the modules in the database Open a report in design view and add a text box to your report The text box will be modified to contain a barcode Right click on the text box and choose properties Place the formula PrecisionID_UPC_A Table1 Field1 or to create
Download Pdf Manuals
Related Search