Home

TBarCode OCX User Manual V11

image

Contents

1. Figure 12 Data Binding in Microsoft Access Please ensure that the barcode type corresponds with the data that you want to encode If the source string contains characters which cannot be encoded with the selected symbolo gy an error message will be displayed instead of the barcode Hint You can also enter a fixed value or an expression as data source Example The expression fields ArticleNo and Price for the EAN13 P5 7 3 3 Specify Data via VBA Code ArticleNo Price could be used for concatenating the data Using VBA Visual Basic for Applications you can specify the barcode data per code For more information please refer to section 8 4 WWW TEC IT COM Page 24 of 73 8 Programming TBarCode VBA 8 1 General TBarCode can be used in Microsoft Office and all other applications e g development environ ments which support ActiveX controls The TBarCode object can be inserted as part of any form document report or spreadsheet and it can be created as invisible instance which is used for printing only This chapter gives basic introductions on how to use the TBarCode OCX with VBA For additional information and sample applications check out Appendix A 8 2 Microsoft Office and VBA Upon insertion the TBarCode control is usually named TBarCode11n where nis a consecutive number This name can be used for addressing the TBarCode control in the VBA code You ca
2. Figure 25 Property Page Appearance 10 3 1 General 10 3 1 1 Orientation Specifies the orientation of the barcode Selectable values are 0 90 180 and 270 The barcode is rotated counter clockwise Please note Some fonts for the human readable text do not support rotation e g some bitmap fonts If rotation is required we recommend selecting a TrueType font 10 3 1 2 Print Ratio The print ratio is the relationship between the bar widths and the space widths of a barcode Another term for print ratio is bar width ratio or bar space width ratio gt By default there is no need to change the print ratio unless needed for any special appli cation Please consider Barcodes may become unreadable when manipulating this value The print ratio must be specified in a specific format This format depends on the number of different bar and space widths used in the selected symbology Example If a barcode element has 4 different bar widths and 4 different space widths the print ratio looks like this Code 128 1 2 3 4 1 2 3 4 In the first part 1 2 3 4 the width ratio of the bars is set in the second part the relation of the spaces is set in our case they are the same The small est bar is 1 wide the next larger is 2 wide thus twice as wide as the smaller bar and so on For more information on print ratios please refer to the Barcode Reference see Appendix A 10 3 1 3
3. Go to the Developer tab and select Insert More Controls WWW TEC IT COM Page 13 of 73 fl Properties B T Map Properties Qe View Code 5 a 3 Run Dialog cal i Refresh Data Form Controls AML Expansion Packs ja eM EK D A abl Ge Ee a a EEE a HM efi 2 AAW x More Controls Insert a control from the set of controls available on this computer Figure 4 Excel 2007 More Controls More Controls TBarCode3 TBarCode4 TOsartndac Figure 5 Excel 2007 Select TBarCode1 1 Select TBarCode 11 from the list of object types and confirm with OK Now move the mouse cursor to the desired position and draw a rectangle to the position where the bar code should be A TBarCode control will be inserted Please note In Word 2007 and Excel 2007 the Control Toolbox can be found in the Developer tab in Access 2007 inside the Design Tab For inserting barcodes in Microsoft Excel 2003 use the TBarCode QuickStart manual provided in the Windows start menu 5 3 3 Insert Barcode in Access 2007 Open anew report in Design View ot Labels Lie 3 _ Blank Report Report Query ues Esk Report Wizard Wizard Lih Reports New Object Report Create a new blank report in Design view in Design view you can make advanced design changes to reports such as adding custom control types and writing code Click the ActiveX Controls symbol
4. Add Custom Control Wizard you have to decide which kind of data you want to encode If you plan to encode single data fields e g the content of an input box please follow the instructions in section 9 3 1 1 1 If you plan to encode the underlying InfoPath XML document or parts of the XML docu ment please follow the instructions in section 9 3 1 1 2 9 3 1 1 1 Encode Single Data Fields Perform these steps if you plan to encode single data fields Add Custom Control Wizard pa Select the binding property Specify a Binding Property Text see Bind an ActiveX control property to a field in the data source of the form template this allows data en Click Next ET On the next page Specify and QuetZonecoortap Enable or Disable Property QuietZoneRight select the entry Enabled Click Next TextBlockWidth TextClipping TextColor TextDistance TextPositionLeft TextPositionTop TextRotation TrimSpaces Value WWW TEC IT COM Page 36 of 73 Define a data type for the ActiveX control Field or group type Field element or attribute Select one or more data types Text string Whole Number integer Decimal double True False boolean Hyperlink anyURI Date date Time time See You can also specify a default data type to use when adding this control to a blank form template Default data type Text string In select Field element or attribu
5. Addressee File size Checksum CCITT 16 Figure 36 Advanced Properties PDF417 gt Please take care when modifying these properties Some settings may result in unreadable barcodes Always make a test scan in case of doubt 10 13 1 PDF417 These settings apply for all PDF417 based barcodes PDF417 PDF417 Truncated and MicroPDF417 WWW TEC IT COM Page 61 of 73 10 13 1 1 Rows 3 90 Specifies the number of rows of one PDF417 symbol Values between 3 and 90 are allowed Default the number of lines rows is calculated automatically depending on the amount of input data 10 13 1 2Row height 1 1000 mm Sets the height of an individual row in 1 1000 mm Default the row height is calculated automatically depending on the bounding rectangle and the number of rows Some label specifications require a specific ratio between module width and row height Example If a ratio of 1 3 is required you might set the module width to 254 and the row height to 762 10 13 1 3 Columns 1 30 Defines the number of columns of a PDF417 symbol Values between 1 and 30 are allowed The Start stop and line indicator columns which are fixed parts of the symbol are not taken into ac count Default the number of columns is calculated automatically depending on the number of input characters You should not set both rows AND columns to a constant value 10 13 1 4Error Correction Level Set
6. Default Selects the mask pattern automatically recommended 0 3 Selects one of the mask patterns 0 to 3 manually Manual selection may be useful if you want to generate many symbols within minimal computa tion time The algorithm for identifying the optimal mask automatically is complex and resource consuming However the readability of the barcode may suffer when using manual selection Table 14 Han Xin Code Mask Patterns 10 12 Adjust Properties MaxiCode MaxiCode represents data by drawing hexagonal items which are arranged around a circular center bull s eye The internal data structure is regulated by different modes The Structured Carrier Message mode was defined by the United Parcel Service UPS Data can be encoded with two different error correction levels SEC Standard Error Correction and EEC Enhanced Error Correction MaxiCode is very flexible With structured append you can divide larger quantities of data into seve ral MaxiCode symbols they are then re joined by the scanner The maximum data capacity of one symbol is 93 characters The actual quantity of the utilizable data depends on the selected mode the number of special characters and whether numeric sequences are used or not numeric sequences can be encoded using less space than ASCII data Last but not least the error correction level influences data capacity MaxiCode Properties m Made 4 Standard symbol
7. Select the TBarCode object Then click on the Properties icon in the Control Toolbox The property list will appear Select the property LinkedCell and enter the name of the cell that you want to bind to the TBarCode control see In this sample B4 is used Mr 7 Bookl Microsoft Excel Drawing Tools o Home Insert Page Layout Formulas Data Review View Developer Add Ins Team Format a d oO ep a e Record Macro amp A Se bs 2 Sf Properties e f Map Properties ZA Import e Z is Use Relative References 2 3p Gal vies 2 Expansion Packs 7 Export ig Visual Macros Add Ins COM Insert sure Document Basic A Macro Security Add Ins x 9 Run Dialog Ref Dat Panel Code Add Ins Controls XML Modify E TBarCode111 v fe EMBED TBarCode11 TBarCode11 1 v A B E D E F G H 1 2 3 Barcode Data Properties 4 Encoded Data O TBarCode111 TBarCode11 6 7 77 25 8 C 9 10 11 12 l 13 Encoded Data 7 14 15 16 cy 18 19 20 21 22 23 24 E 26 z M 4 gt M Sheeti Sheet2 Sheet3 J Hal i f Ready 2 S 10 Figure 11 Data Binding in Microsoft Excel 7 3 2 Microsoft Access The barcode control is likely to be used in reports and forms Barcode data can be added manually or automatically by binding it to a table column In the second case the barcode changes according to the data record which is currently be
8. Option Button Rule Rules Clipboard E Font Styles Controls E Rules Form Controls Insert controls Containers ml Section Optional Section IF Repeating Section Add tables LE Scrolling Region bead Horizontal Region heil Repeating Recursive Section fa Horizontal Repeating Table Master Detail ll Choice Group lal Repeating Choice Group E Choice Section Custom WM Barcode 11 Automatically create data source Add or Remove Custom Controls Figure 21 Add TBarCode to the Custom Controls in Microsoft InfoPath 2010 4 WWW TEC IT COM Page 38 of 73 9 3 2 Insert Barcode After you added TBarCode OCX to the Custom Controls in Microsoft InfoPath see section 9 3 1 you can add a barcode to your document by performing the following steps Place the cursor where you want to insert the barcode and click on the TBarCode control in the Controls Pane Before the barcode is actually inserted a dialog named 7BarCode11 Binding appears Select the required field or group 4 as data source see The content of the selected entry will be encoded as barcode Please note If you have selected single data fields as data source type see 9 3 1 1 1 you can select fields only no groups Press OK A new barcode object will be inserted Tid mr Wellies Design Formi Microsoft InfoPath Se Z File Home Insert Page Design Data Developer Layout es amp L Refresh Fields a
9. the last two digits of a year can be entered They are automatically inserted into the data stream in a predefined place The preamble can also be specified by escape sequences in the Barcode data alias Text proper ty To learn more about this option please refer to the Barcode Reference see Appendix A 10 12 3 1 Use Preamble Enables the preamble mode if checked 10 12 3 2Preamble date 0 99 This is the value of the preamble year to be encoded in the MaxiCode symbol 10 12 4 Structured Append Structured append is used for appending multiple MaxiCode symbols to one chain Therefore some Same header information total number of barcodes index will be included in the barcode Using structured append a large amount of input data which is split up into multiple barcode sym bols can be re joined correctly even if the barcodes are read in the wrong order 10 12 4 1 Use structured append Activate this option if structured append should be activated 10 12 4 2Number of all symbols 2 8 The total number of MaxiCode symbols must be specified in this field 10 12 4 3Index of this symbol 1 8 The symbol identification number index can be assigned to each MaxiCode symbol Its value can range from 1 to 8 The index is used for identifying the correct re joining order 10 12 5 Structured Carrier Message SCM MaxiCode was originally developed by UPS United Parcel Service The operating modes 2 and 3 Structured Carri
10. Auto kd 2 digits 1 char Size Mode Default Ratio Size Print Direction Enforce Binary Encoding r Structured Append Use Structured Append m Number of all Symbols 2 35 2 Index of this Symbol 1 35 1 Figure 33 Advanced Properties DotCode 10 10 1 Format Format Specifier You can choose from Auto discriminate between UCC EAN GS1 format and generic format If the data starts with 2 digits data is handled as GS1 format otherwise it is handled as generic format Data is handled as generic format If it starts with 2 digits FNC1 is added on first position GS1 UCC EAN Special format defined by GS1 Used for encoding so called Application Identifiers FNC1 is added at first position Industry For special industry formats If you choose this value you have to fill in a Format Specifier 2 digits or 1 letter It determines which industry format the barcode data corresponds to FNC1 is inserted at second position Table 11 DotCode Formats 10 10 2 Size Mode The Size Mode specifies either the Ratio between Height and Width or the number of rows Fixed Height or columns Fixed Width Default specifies a ratio of 4 3 10 10 3 Ratio Size Depending on the Size Mode this setting defines either the aspect ratio width height or the number of columns or rows 10 10 4 Print Direction Set the print direction for which the DotCode symbol is to be
11. Calibri fis r Effects 1 Bald Underline Italic Strikeout Sample Text Calibri Figure 27 Property Page Font 10 4 1 Properties The entry Font is pre selected 10 4 2 Font Selects the font type The combo box lists all fonts which are available under your operating system 10 4 3 Size Specifies the font size in points 10 4 4 Effects Applies additional text effects Please check the corresponding option to create bold italic under lined and or stroked out text WWW TEC IT COM Page 50 of 73 10 4 5 Sample Text Shows a preview of the selected font 10 5 Property Page Color The colors of the barcode of the human readable text and of the background can be set here TBarCodell Properties Barcode Appearance Font Color Properties Color Set E B2ckco10 fa Standard Colors as Color Palette Quiet oneColorE oDeoneColorl 7 u TextColor Edit Custom Color Figure 28 Property Page Color In order to change the color for one of the barcode components background foreground human readable text you have to select the corresponding property in first Then click on the desired color in 10 5 1 Properties Select the property that you want to change BackColor The background color of the barcode color of the spaces If the back style is set to Transparent the adjuste
12. Undercut 0 100 WW Defaut m Preamble options Use preamble E Preamble date 0 95 36 M Structured append r Structured carier message 5 CM Use structured append u Service class 0 999 Number of all symbols 2 9 E Country code 0 999 Index of this sembol 1 8 fi Postal code 9 digita area Figure 35 Advanced Properties MaxiCode WWW TEC IT COM Page 59 of 73 10 12 1 Mode Selects the mode for the actual symbol Default Mode 4 Value Description Default Is equal to Mode 4 i SCM Numeric gt Structured Carrier Message with 9 digits Postal Code digits only SCM Alphanumeric Structured Carrier Message with up to 6 characters Postal Code alphanumeric characters No SCM encoding of numeric and alphanumeric characters incl Standard Error Correction Full EEC like mode 4 but with maximum error correction safer but less data possible Table 15 MaxiCode Compaction Modes 10 12 2 Undercut 0 100 The undercut influences the diameter of the hexagonal barcode elements In new applications it is recommended according to the AIM standard to use an undercut setting of 75 default 10 12 3 Preamble Options Used in particular open system standards Under Preamble date
13. 2D barcodes These values are recommended for most hardware scanners Software Select this option if the barcode symbol is received as an image e g via flat bed scanner camera fax software etc and decoded via software solution This setting guarantees a minimal module width of 5 pixels This value ensures reada bility by most software decoders TBarCode InForm Select this option if you plan to use the upcoming TBarCode software solution for decoding the barcode symbol Table 8 Decoder WWW TEC IT COM Page 49 of 73 10 3 4 Display Error if Barcode is clipped For certain configurations it is possible that the barcode grows bigger than the bounding rectangle In this case all bars which extend the size of the bounding rectangle are clipped by default To make sure that the barcode does not remain unreadable because of clipped regions you can check the option Display error if barcode is clipped If this property is set and if the barcode extends the size of the bounding rectangle no barcode will be drawn at all Instead an error is dis played This option may help you to avoid truncated barcodes incorrect printouts can be detected immedi ately 10 4 Property Page Font In this menu you can adjust the font for the human readable text TBarCodell Properties Barcode Appearance Font Color Properties Font Size Font
14. 48 for a rectangular symbol When set to default the minimal square size is used depending on input data 10 9 3 Enforce Binary Encoding If checked binary mode is used for encoding no input data analysis This mode is recommended if you want to encode binary input data 10 9 4 Show as Rectangle Determines if the Data Matrix symbol should be displayed as rectangle checked or square unchecked default 10 9 5 Structured Append If you want to connect several Data Matrix symbols in order to encode larger quantities of data you can use Structured Append 10 9 5 1 Use structured append Activates structured append symbol chaining with this option 10 9 5 2 Number of all symbols 2 16 Enter the total number of chained Data Matrix symbols here A maximum of 16 symbols may be used within one chain 10 9 5 3 Index of this symbol 1 16 A symbol identification number which is entered in the index field must be assigned to each Data Matrix symbol Its value can range from 1 to 16 This index indicates the order in which the data is joined after the reading scanning process 10 9 5 4 File ID 1 64516 The File ID has to be the same for all symbols within a chain 10 10 Adjust Properties DotCode DotCode is a 2D dot code symbology which means that 2 dots are always separated by at least on space WWW TEC IT COM Page 56 of 73 DotCode Properties General Format Format Specifier
15. Bearer Bars Table 4 Draw Mode Table 5 Text Alignment Table 6 Size Mode Table 7 Resolution Table 8 Decoder Table 9 Codablock F Code Formats Table 10 Data Matrix Code Formats Table 11 DotCode Formats Table 12 DotCode Mask Patterns Table 13 Han Xin Code Error Correction Levels Table 14 Han Xin Code Mask Patterns Table 15 MaxiCode Compaction Modes Table 16 PDF417 Error Correction Levels Table 17 Micro PDF417 Compaction Modes Table 18 QR Code Formats Table 19 QR Code Error Correction Levels Table 20 QR Code Mask Patterns Table 21 QR Code Compaction Modes Table 22 Composite Component Format WWW TEC IT COM 42 44 46 46 48 48 49 49 55 56 57 58 59 59 60 62 63 64 65 65 65 67 Page 6 of 73 2 Disclaimer The actual version of this product document is available as is TEC IT declines all warranties which go beyond applicable rights The licensee or reader bears all risks that might take place during the use of the system the documentation TEC IT and its contractual partner cannot be penalized for direct and indirect damages or losses this includes non restrictive damages through loss of revenues constriction in the exercise of business loss of business information or any kind of commercial loss which is caused by use or inability to use the product documentation although the possibility of such damage was pointed out by TEC IT We reserve all rights to this document and the i
16. Control Wizard lt Add Custom Control Wizard Select a Control Type Select an ActiveX Control Custom controls provide functionality that can be reused across many forms You can select an ActiveX control thatis installed on your computer and make it available in the i Controls task pane gt Template Part Template parts can be created in InfoPath and contain controls a data source and other features Select a control Microsoft Toolbar Control version 6 0 Microsoft TreeView Control version 6 0 nen 3 Microsoft Visio Document ActiveX Control MMC IconControl dass A control that uses COM and ActiveX technologies ActiveX controls MMCCtl dass must be installed on each user s computer MSREdit Class OleInstall Class OWS Post Data PaneLocator Class PrinterQueueView Class RDPViewer Class Ref dit Ctrl RoomsCTP Control Class ScriptControl Object STSUpld CopyCt Class SysColorCtrl dass Tabular Data Control TaskSymbol Class a IE Details na Find additional custom controls on Office Marketplace 111 men ae Neutral ersion 1 Figure 20 Add TBarCode to the Custom Controls in Microsoft InfoPath 2010 3 Choose whether you want to use a cab file click Next On the following wizard pages you have to specify the data source type for TBarCode This selection determines how the barcode control can be used in InfoPath later on For more information please see below 9 3 1 1 Specify Data Source Type In the
17. Edit view Insert Format Tools Table Help Preview Form GH Le er Data source To set the binding select a field or group in which to store the control s data Ef dateAssigned gt assignedTo Ef dateOpened gt openedBy Ef dateclosed gt closedBy S issue 58 signatures Description Figure 16 Insert TBarCode in a Microsoft InfoPath 2003 Document 9 2 4 Change Binding number Control stores duplicate data number Control stores duplicate data More Details Change Binding IN Adjust Propert z Dantad kifonmarlar Show Data Source Requested By Phone Number with OK E mail Address Change To TBarCode Properties WWW TEC IT COM aaa Type a question for help wi Controls IE Layout Controls ta Data Source E views Insert controls a Hyperlink As Expression Box WE Vertical Label lH Scrolling Region ll Choice Group al Repeating Choice Group E Choice Section heil Repeating Recursive Sech n Custom ll TBarlode A Automatically create data source Add or Remove Custom Controls Help with Controls To change the binding which was specified upon insertion of TBarCode see Figure 16 right click on the bar code and select Change Binding The TBarCode11 Binding dialog appears from the pop up menu Select a field or group from the tree vie
18. Ribbon and keyboard shortcut Display Choose commands from i Customize the Ribbon G Proofing Popular Commands Main Tabs Save L Accept and Move to Next a Main Tabs anguage Align Left V Home Advanced Breaks gt W Insert Bullets gt V Page Layout Change List Level gt F Mailings Quick Access Toolbar 23 Copy V Review Add Ins m a i B Wi View i Define New Number Format Document Views Trust Center XJ Delete Show A Draw Table Zoom 4 Draw Vertical Text Box Window Q E mail Macros 4 Find T V Developer 6 Font i V Add Ins A Font F Blog Post Ly Font Color gt E W Insert Blog Post Font Size Ir ed Outlining J Format Painter 7 Background Removal A Grow Font Q Hyperlink AB Insert Footnote H Line and Paragraph Spacing gt gt Macros _ New D New Comment 2 Next New Tab New Group Rename Z__Numberina gt E o Customizations i Keyboard shortcuts OK Cancel Then go to the Developer tab and click Legacy Tools More Controls Select TBarCode11 from the list of ActiveX Controls and confirm with OK The barcode will be inserted at the current cursor position wi ld 9 O Docu Home Insert Page Layout References Mailings Review View EJ Record Macro amp s Aa Aa G Design Mode E II Pause Recording FE EH T Properties Visual Macros Add Ins COM taj moe g Group Stru Basic A Macr
19. Size Print Direction Enforce Binary Encoding Mask Structured Append 10 10 7 1 Use Structured Append 10 10 7 2 Number of all Symbols 2 35 10 10 7 3 Index of this Symbol 1 35 10 11 Adjust Properties Han Xin Code Symbol Version Size Enforce Binary Encoding Error Correction Level Mask Pattern Adjust Properties MaxiCode Mode Undercut 0 100 Preamble Options 10 12 3 1 Use Preamble 10 12 3 2 Preamble date 0 99 10 12 4 Structured Append 10 12 4 1 Use structured append 10 12 4 2 Number of all symbols 2 8 10 12 4 3 Index of this symbol 1 8 10 12 5 Structured Carrier Message SCM 10 12 5 1 Service class 0 999 10 12 5 2 Country code 0 999 10 12 5 3 Postal code 9 digits 10 13 10 13 1 Adjust Properties PDF417 PDF417 Rows 3 90 Row height 1 1000 mm Error Correction Level Encoding Mode MicroPDF417 1 1 1 2 1 3 Columns 1 30 1 4 1 5 10 13 2 1 Mode 10 13 2 2 Version Macro PDF417 structured append Adjust Properties QR Code QR Code 2005 Format Application Indicator Symbol Version Size Error Correction Level Mask Pattern Compaction Structured Append 10 14 6 1 Use Structured Append 10 14 6 2 Parity Byte 0 255 10 14 6 3 Number of all Symbols 2 16 10 14 6 4 Index of this Symbol 1 16 10 15 10 15 1 10 15 2 10 15 3 10 15 4 10 16 10 16 1 Adjust Properties Micro QR Code Symbol Version Size Error Correction Level Mask Patte
20. TE From SharePoint List F Z 3 as EQ Resource Files Eh From SharePoint Server ee gt lt p From Web Data To ToSharePoint To Other Submit Form Form Rule User Se EJ Default Values Service Bar From Other Sources Connecions E mail Library Locations Options Load Submit Inspector Roles Form Data Get External Data Submit Form Rules Roles TBarCodell Binding f a Controls Data source Insert controls Main myFfields E assignedTo To set the binding select a field or group in which to store the control s data lo Section lal Optional Section E dateAssigned IF Repeating Section dateOpened Esl Repeating Table oo i LE Scrolling Region bead Horizontal Region heil Repeating Recursive Section EH Horizontal Repeating Table Master Detail E Choice Group lal Repeating Choice Group E Choice Section u TBarlodeii Automatically create data source Add or Remove Custom Controls Figure 22 Insert TBarCode in a Microsoft InfoPath 2010 Document 9 3 3 Change Binding Calibri 10 3 EE AD To change the binding which was specified upon insertion I ZA gt s of TBarCode see Figure 22 right click on the bar Cut code and select Change Binding from the pop up menu Fapt la The TBarCode11 Binding dialog appears z gt A aca Select a field or group from the tree view and confirm J Borders and Shading with OK Change Contro
21. and to provide your own check digits usually by program code or to use all possible digits for utilizable data in non standard applications Under normal circumstances you should not use this feature we recommend the automatic cal culation of check digits by TBarCode 10 2 8 Compression To increment the capacity of barcodes you can compress the Barcode Data This means that the data provided by the user will be compressed before it is encoded as barcode The compression is only available for barcodes which allow the encoding of arbitrary binary data and a variable length of input data By default the compression is set to None WWW TEC IT COM Page 43 of 73 We recommend using this algorithm if data compression is required Table 2 Compression gt Note When reading compressed barcode data you will have to decompress it in order to restore the original input data Decompression can be done through the TBarCode InForm software decoder which restores the uncompressed data automatically Or you can use any third party software library for decompression 10 2 9 Suppress Error Messages If the barcode data contains invalid characters e g letters for code 2 of 5 Interleaved or if the wrong number of input characters is provided an error message is displayed instead of the bar code If Suppress error message is enabled this error message will be suppressed Only blank space is displayed i
22. ee ee ung Help with Controls n on EF Figure 14 Add TBarCode to the Custom Controls in Microsoft InfoPath 2003 2 9 2 2 1 Specify Data Source Type In the Add Custom Control Wizard you have to decide which kind of data you want to encode f you plan to encode single data fields e g the content of an input box please follow the instructions in section 9 2 2 1 1 f you plan to encode the underlying InfoPath XML document or parts of the XML docu ment please follow the instructions in section 9 2 2 1 2 WWW TEC IT COM Page 30 of 73 9 2 2 1 1 Encode Single Data Fields Perform these steps if you plan to encode single data fields Add Custom Control Wizard Specify a Binding Property Bind an Activex control property to a Field in the form s data source this allows data associated with the control to be sawed Binding property RSS SegmPerRow SizeMode se arin Text alignment TextColor Add Custom Control Wizard Specify Data Type Options Define a data type for the Activex control Field or group type Field element or attribute D wt Select one or more data types Text string Whole Number nteger Decimal double True False boolean Hyperlink tany URI Date date Time time You can also specify a default data type to use when adding this control to a blank Form Default data type Text string 4 F Select the binding propert
23. field Licensee enter the name that you entered as licensee at the time of your purchase or OF Cancel ce the name that was assigned to you when you received the license key Under Kind of License select the kind of license that you have purchased You can select Single Einzellizenz Site Firmenlizenz Developer Entwicklerlizenz Under Number of Licenses enter the number of li censes that you have purchased In the field Your license key enter the license key exactly as you received it from TEC IT WWW TEC IT COM Page 69 of 73 12 Contact and Support Information TEC IT Datenverarbeitung GmbH Address Hans Wagnerstr 6 AT 4400 Steyr Austria Europe Phone 43 0 7252 72 720 Fax 43 0 7252 72 720 77 Email mailto support tec it com Web http www tec it com AIX is a registered trademark of IBM Corporation HTML DHTML XML XHTML are trademarks or registered trademarks of W3C World Wide Web Consortium Laboratory for Computer Science NE43 358 Massachusetts Institute of Technology 545 Technology Square Cambridge MA 02139 JAVA is a registered trademark of Sun Microsystems Inc 901 San Antonio Road Palo Alto CA 94303 USA JAVASCRIPT is a registered trademark of Sun Microsystems Inc used under license for technology invented and implemented by Netscape Microsoft Windows Microsoft Word Microsoft Excel are registered trademarks of Microsoft Corpo
24. is always passed as UNICODE stream to TBarCode OCX As UNICODE characters always consist of 2 bytes and most of the barcode types are only able to encode one byte per character it is not always clear how the input data should be interpreted So we give you the possibility to decide yourself Per default the input data is converted to the selected Code Page see below If other kinds of interpretations are needed you have to change this property You have following possibilities Value Description Convert to Code Page Converts the input data to the code page which is selected in the property Code Page default No conversion Lower bytes only Considers only the lower bytes of the input characters the higher bytes are ignored Bytestream Lower before higher byte The data is passed as it is No conversion is done Both bytes are considered The lower byte is passed before the higher byte Bytestream Reverse Higher before lower byte Consider both bytes but change the order of lower and higher byte That means the higher byte is encoded before the lower byte Converts the input data which must consist of hexadecimal values to binary data Pairs of hexadecimal values are converted to according byte values As Hexadecimal Characters Table 1 Compression 10 2 5 Code page The code page is related to t
25. new report in Design View Create Report Design r Pen este a S S Labels Report Blank Macro Report Reports he HHL Report Design Create a new blank report in Design view In Design view you can make advanced design changes to reports such a5 adding custom control types and writing code Click the ActiveX Controls symbol in the section Design Controls Report Design Tools Databa Database Tools Design Arange Format Page Setup eas eta S details Insert als Bill Bode A n Irira ye Heade sa tL EN Use Control Wizards WWW TEC IT COM Page 17 of 73 Select TBarCode11 from the list of ActiveX Controls and confirm with OK Select an ActiveX Control OleInstall Class OWS Post Data PaneLocator Class PrinterQueueView Class RDP Viewer Class RefEdit Ctrl RoomsCTP Control Class ScriptControl Object STSUpld CopyCd Class SysColorCtrl dass System Monitor Control Tabular Data Control TaskSymbol Class En Ta soro Control Result Inserts a new TBarCode 11 into your document A TBarCode control will be inserted 5 5 Insert Barcode per Code Using VBA Visual Basic for Applications you can insert the barcode per code For more informa tion please refer to section 8 3 WWW TEC IT COM Page 18 of 73 6 Adjust Barcode Parameters 6 1 General TBarCode offers the possibility to change all barcode related settings barcode type b
26. optimized regarding the robustness of the symbol It has only effect if Size Mode is either Default or Ratio Width Height 10 10 5 Enforce Binary Encoding If checked binary mode is used for encoding no input data analysis This mode is recommended if you want to encode binary input data WWW TEC IT COM Page 57 of 73 10 10 6 Mask Selects the mask pattern which is applied to the encoded data XOR masking The goal of the mask pattern is to distribute the bar space transitions evenly over the symbol in order to improve the readability of the barcode Selects the mask pattern automatically recommended Selects one of the mask patterns 0 to 3 manually Manual selection may be useful if you want to generate many symbols within minimal computa tion time The algorithm for identifying the optimal mask automatically is complex and resource consuming However the readability of the barcode may suffer when using manual selection Table 12 DotCode Wack Patterns 10 10 7 Structured Append 10 10 7 1 Use Structured Append Activates structured append symbol chaining with this option 10 10 7 2Number of all Symbols 2 35 Enter the total number of chained DotCode symbols here A maximum of 35 symbols may be used within one chain 10 10 7 3Index of this Symbol 1 35 A symbol identification number which is entered in the index field must be assigned to each DotCode symbol Its v
27. please refer to chapter 10 WWW TEC IT COM Page 20 of 73 6 3 2 Property List Frome ie kB AG mi Properties Structure a Block Restrict Document Document Expansion Packs Authors Editing Template Panel yntrols XML Protect Templates TBarCode111 rc TBarCode111 0 SHOOFFFFFF amp Ii AI ee Bz Code 1 Cut e Copy a Pae Options apelmagerile Bl oe View Code TBarCodell Object gt EA Hyperlink Y Format Control DefaultColorForQuietZon True DefaultColorForQuietZon True DefaultColorForQuietZon True DefaultColorForQuietZon True Figure 10 Property List Microsoft Word Application How to open the Property List Word Make sure that you are in Design Mode see section 6 2 Right click on the TBarCode object and select Properties from the pop up menu Access As an alternative you can also select the barcode and click on the Properties icon in the Control Toolbox The property pages will appear InfoPath No property list available gt Some properties in particular data binding Linked Cell in Excel or Control Source in Access are available in the property list only For more information on data binding please refer to section 7 3 Excel 6 3 3 Adjust Parameters per Code Using VBA Visual Basic for Applications you can adjust the barcode parameters per code For more information please refer to section 8 4 W
28. 1 from the list of object types and confirm with OK A new barcode object will be inserted Access Open your report or form in the design mode see 6 2 Select Insert ActiveX Control from the menu Select TBarCode 11 from the list of object types and confirm with OK A new barcode object will be inserted 5 2 2 Insert Barcode in Word 2003 using the Control Toolbox T Document3 Microsoft Word 3735 A File Edit view Insert Format Tools Table Window Help f P s z 23 m 9 Mn Type a question for help X gt Figure 2 Insert Barcode using the Control Toolbox Microsoft Word Mm SysColorCtrl class System Information System Monitor Control Tabular Data Control TaskSymbol Class TConnector A TelnetLnk TelnetLink Adjust P Adjust Properties 284 controls 4131200401 Mg gt Please note In Word and Excel the toolbar is named Control Toolbox in Access just Tool box Application How to insert If the Control Toolbox is not visible please open it as follows right click on one of the visible toolbars and select Control Toolbox or select View gt Toolbars Control Toolbox from the menu Click on the More Controls icon A list with available controls will appear see Select the entry TBarCode11 Now move the mouse cursor to the desired position and click the left mouse button The TBarCode control will be inserte
29. 2 or L4 Code128 FNC2 Emulation Code 128 with FNC2 on first position will be emulated Linked UCC EAN 128 Linked UCC EAN 128 emulation Transmit C1 or L3 This mode links the MicroPDF symbol with a linear 1D symbol The linked symbol may be required for a successful scan The symbol can be encoded with better compaction when using one of the following orders for Application Identifiers Als date Al 11 13 15 or 17 lot number Al 10 other Als optional date Al 11 13 15 or 17 serial number Al 21 other Als optional date Al 11 13 15 or 17 other Als optional Note This mode is not used with UCC EAN Composite Symbology which uses linked symbols as well The preamble gt RS 0 5 GS precedes the barcode data The preamble gt RS 0 6 GS precedes the barcode data CC A Data Mode Uses Base 928 compaction and processes input data as byte array CC B Data Mode Uses binary compaction Base 900 The barcode data is prefixed with a reserved code word Table 17 Micro PDF417 Compaction Modes 10 13 2 2 Version Specifies the size of the symbol in terms of codeword columns and MicroPDF417 rows 10 13 3 Macro PDF417 structured append Macro PDF417 is used for connecting multiple PDF417 symbols PDF417 PDF417 Truncated or MicroPDF417 into one chain For each symbol of the chain you can specify the Segment Index of the actual symbol Last symbol specifies that the actual sy
30. 64 bit 4 2 Download and Setup Download TBarCode SDK from http www tec it com Download gt TBarCode SDK and execute the setup application Depending on your selection one or more of the following components are installed along with documentations and sample applications TBarCode OCX A barcode ActiveX control for Microsoft Office users and for software developers User manual and API reference are included in the setup TBarCode Library For software developers Developer manual and API reference are included in the setup TBarCode NET For NET developers Developer manual and API reference are included in the setup Administrative rights are required to install TBarCode SDK TBarCode OCX is an ActiveX control ActiveX controls must be registered within the Micro soft Windows operating system before they can be used This registration is executed auto matically by the setup application On demand you can register the OCX file manually with the command line tool regsvr32 exe WWW TEC IT COM Page 10 of 73 5 Insert Barcode into Microsoft Office 5 1 General This and the following chapters will explain how to use TBarCode in Microsoft Office applications For the following three products the usage of the TBarCode control is basically the same see TBarCode QuickStart manual Microsoft Word 2003 and earlier versions Microsoft Excel 2003 and earlier versions Microsoft Access 2003 and earlier ve
31. Back Style The barcode can be painted with transparent background default background shines through or with opaque background background is drawn in the adjusted color WWW TEC IT COM Page 45 of 73 gt Ifthe back style is set to Transparent the adjusted background color will be ignored 10 3 1 4 Bar Width Reduction Sets the bar width reduction in percent When printing on inkjet printers the ink that is absorbed by the paper tends to diffuse Setting the bar width reduction allows you to work against this spreading of ink But also for laser printers with high toner saturation this property is useful The bar width reduction can be specified in percent of the module width Thus when set to 20 all bars will be narrowed by 20 percent of the module width gt Be careful Setting the bar width reduction to more than 50 percent might leave the bar code unreadable When using this feature we recommend you to do some test scans to make sure that the bar code can be scanned correctly A common value to start with is 15 10 3 1 5 Bearer Bars Usually bearer bars are used with the ITF 14 or sometimes with the Interleaved 2 of 5 or the DPD symbology only The bearer bars were introduced to equalize the pressure exerted by the printing plate over the entire surface of soft materials They also enhance the reading reliability by helping to reduce the probability of misreads by skewed scanning beams For some types
32. Format Activate Adjust the size of the barcode by adjusting the shape The barcode object extends to the size of the shape by default oShape Width 200 oShape Height 100 Get the barcode object within the shape Set oTBC oShape OLEFormat Object Adjust the barcode object properties barcode type barcode data oTBC BarCode 20 Dealeri Coo s125 meen Coce mercer Coce lA STBC Text 77234567890 set barcode data This samples inserts TBarCode as OLE Object To insert the barcode as OLE Control you have to use the command AddOLEControl 8 3 2 Microsoft Excel This sample shows how to insert a Code 128 symbol in cell C3 on the current spreadsheet The barcode data will be set to 123456 and the size of the human readable text to 8 points Dim TargetCell As Variant The cell in which you want to insert the barcode Dim CellHeight As Variant Height of the target cell Dim CellWidth As Variant width of the target cell Dim CellTop As Variant Top coordinates of the target cell Dim CellLeft As Variant Left coordinates of the target cell Dim BCObject As OLEObject The TBarCode container object TargetCell C3 Make sure that the cell height has 30 pixels minimum If Range TargetCell RowHeight lt 30 Then Range TargetCell RowHeight 30 mne LE Get target cell dimensions CellHeight Range TargetCell Height CellWidth Range TargetCell Width CellTop Range TargetC
33. Microsoft Excel Adjust Barcode Parameters and Barcode Data Microsoft Word or Excel Microsoft Access License TBarCode Barcodes in Microsoft InfoPath General InfoPath 2003 Activate the Design Mode Add TBarCode to the Custom Controls 9 2 2 1 Specify Data Source Type 9 2 2 2 Finish Adding the Custom Control 9 2 3 9 2 4 Insert Barcode Change Binding WWW TEC IT COM o0o0 00090 N OAN Page 2 of 73 10 9 2 5 Adjust Barcode Parameters 9 3 InfoPath 2010 InfoPath 2013 9 3 1 Add TBarCode to the Custom Controls 9 3 1 1 Specify Data Source Type 9 3 1 2 Finish Adding the Custom Control 9 3 2 Insert Barcode 9 3 3 Change Binding 9 3 4 Adjust Barcode Parameters The Property Pages 10 1 Introduction 10 2 Property Page Barcode 10 2 1 Barcode Type Symbology 10 2 2 Button Adjust 10 2 3 Barcode Data 10 2 4 Encoding Mode 10 2 5 Code page 10 2 6 Format Subset 10 2 7 Check Digit 10 2 7 1 Check Digit Override 10 2 8 Compression 10 2 9 Suppress Error Messages 10 2 10 Translate Escape Sequences 10 2 11 Button License 10 2 12 Button About 10 3 Property Page Appearance 10 3 1 General 10 3 1 1 Orientation 10 3 1 2 Print Ratio 10 3 1 3 Back Style 10 3 1 4 Bar Width Reduction 10 3 1 5 Bearer Bars 10 3 1 6 Bearer Bar Width 1 1000 mm 10 3 1 7 Draw Mode 10 3 1 8 Quiet Zone 10 3 2 Text Options 10 3 2 1 Print Text 10 3 2 2 Above Symbol 10 3 2 3 Alignment 10 3 2 4 Text Dista
34. Properties Data Matrix Please note TBarCode always encodes data using the newest ECC200 error correction method In this dialog you can set Data Matrix specific properties Data Matrix Properties ee Code format Defaut O Symbol size Default T Enforce binary encoding E Show as rectangle m Structured append Use structured append u Number of all symbols 2 16 2 Index of this symbol 1 16 File ID 1 64516 fi OF Cancel Figure 32 Advanced Properties Data Matrix 10 9 1 Code Format Sets the code format which is used for encoding the barcode data Default The standard format of Data Matrix no special header included GS1 UCC EAN Special format defined by GS1 for encoding Application Identifiers This format adds the function character FNC1 at 1st position in the symbol WWW TEC IT COM Page 55 of 73 Industry This setting supports peculiar industry formats It adds FNC1 at 2nd position Macro 05 gt Rs05Gs is encoded at the beginning of the code Macro 06 encoded at the beginning of the code Reader This setting activates the reader programming mode Programming code Table 10 Data Matrix Code Formats 10 9 2 Symbol Size Defines the size of the symbol in terms of rows and columns Possible sizes are 70 x 10 to 144 x 144 modules for a square symbol and 8 x 18 to 16 x
35. WW TEC IT COM Page 21 of 73 7 Set Barcode Data Data Binding 7 1 General The barcode data can be provided in three ways Manually Via Data Binding Via VBA Visual Basic for Applications 7 2 Specify Data Manually You can specify the barcode data in the property pages or the property list 7 2 1 Property Pages Open the property pages see section 6 3 1 Select the Barcode tab Enter the desired text in TBarCodell Properties Barcode Appearance Fort Color Basic settings Barcode Type Symbologe Code 128 Barcode Adjust Properties 17 Characters 4 7 2 2 Property List Open the property list see section 6 3 2 Select the Text property Enter the desired text in Properties 8 TBarCode111 TBarlodeii X 1B 28 38 48 15 25 35 45 a 1 Default Fit to bounding rectang False Adjust Properties 2 J Default n v 7 3 Data Binding Some Microsoft Office applications provide the option to bind the content of a specified data field to the TBarCode control data binding This means that the barcode control will use the content of the data field as barcode data Whenever you change the content of the data field the barcode symbol will be updated as well 7 3 1 Microsoft Excel Data binding can be enabled via the property LinkedCell WWW TEC IT COM Page 22 of 73 Make sure that you are in Design Mode see section 6 2
36. WWW TEC IT COM TBarCode Barcode Generator Components Version 11 User Manual 29 January 2013 TEC IT Datenverarbeitung GmbH Hans Wagner Str 6 A 4400 Steyr Austria t 43 0 7252 72720 f 43 0 7252 72720 77 office tec it com www tec it com Content Content 9 2 1 9 2 2 Content List of Figures List of Tables Disclaimer Introduction What is TBarCode SDK Scope of this Document What is TBarCode OCX Restrictions of the Demo Version Important Security Notice Installation Requirements Download and Setup Insert Barcode into Microsoft Office General Microsoft Office 2003 Insert Barcode in Word 2003 using the Menu Insert Barcode in Word 2003 using the Control Toolbox Microsoft Office 2007 Insert Barcode in Word 2007 Insert Barcode in Excel 2007 Insert Barcode in Access 2007 Microsoft Office 2010 Office 2013 Insert Barcode in Word 2010 Word 2013 Insert Barcode in Excel 2010 Excel 2013 Insert Barcode in Access 2010 Access 2013 Insert Barcode per Code Adjust Barcode Parameters General Activate the Design Mode Microsoft Word or Excel Microsoft Access Barcode Parameters Property Pages Property List Adjust Parameters per Code Set Barcode Data Data Binding General Specify Data Manually Property Pages Property List Data Binding Microsoft Excel Microsoft Access Specify Data via VBA Code Programming TBarCode VBA General Microsoft Office and VBA Insert Barcode Microsoft Word
37. WWW TEC IT COM Page 53 of 73 10 7 5 Error Correction in 0 90 Unlike other barcode types the error correction level of an Aztec Code is not described in pre defined levels but can be specified in percent of the data amount Default error correction level is 23 which is recommended but it may be in the range from 0 up to 90 10 7 6 Structured Append If you want to connect several Data Matrix symbols in order to encode larger quantities of data you can use Structured Append 10 7 6 1 Use structured append Activates structured append symbol chaining with this option 10 7 6 2 Number of all symbols A Z Enter the total number of chained Data Matrix symbols here A maximum of 26 symbols may be used within one chain where A stands for 1 and Z stands for 26 10 7 6 3 Index of this symbol 1 16 A symbol identification number which is entered in the index field must be assigned to each Data Matrix symbol Its value can range from A 1 to Z 26 This index indicates the order in which the data Is joined after the reading scanning process 10 7 6 4 Message ID The Message ID has to be the same for all symbols within a chain 10 8 Adjust Properties Codablock F Codablock F is a stacked symbology like PDF417 based upon the Code 128 character set Each row consists of a Code 128 symbol but extended with row indicators row count and sequence number and an additional check digi
38. acters alphanumeric in 3 to 12 rows and 2 to 4 columns CC C Use composite component C CC C The CC C structure is a PDF417 Symbol which is identified by the internal code word 920 920 is the first code word after the symbol length indicator The CC C structure can be used as a 2D composite component of a GS1 UCC EAN 128 Composite Symbol It has the largest data capacity among the composite symbologies It encodes numbers and alphanumeric characters with up to 2361 characters length in 3 to 30 rows It uses up to 30 data error checking code columns Table 22 Composite Component Format WWW TEC IT COM Page 67 of 73 gt You can add Composite Components to the following symbologies EAN 8 EAN 13 UPC E UPC A GS1 DataBar family and EAN 128 CC C is available for GS1 UCC EAN 128 only 10 16 1 1 Data Input for the GS1 Composite Symbology If the composite component is enabled the data for the 2D composite component has to be separated from the linear component with a vertical bar Example 1234567890123 CompositeData If a symbology has a fixed data length such as GS1 DataBar the vertical bar is optional All remaining characters after the 14 digit will be encoded into the 2D component automatically 10 16 2 Segments per Row For the GS1 DataBar Expanded Stacked symbology you can adjust the number of data segments per row Allowed are even values between 2 and 22 This parameter influences the width to height ra
39. alue can range from 1 to 35 This index indicates the order in which the data is joined after the reading scanning process 10 11 Adjust Properties Han Xin Code Han Xin Code is a 2D matrix code like Data Matrix and QR Code It implements special support for Chinese characters character set GB18030 but supports also western character sets like Latin and byte encoding Han Ain Properties r General Symbal Version Size Enforce Binary Encoding Error Correction Level Mask Pattern Figure 34 Advanced Properties Han Xin Code 10 11 1 Symbol Version Size Defines the version size of a symbol Possible sizes are Version 23 x 23 to Version 84 189 x 189 When set to default the minimal square size for given input data is used 10 11 2 Enforce Binary Encoding If checked binary mode is used for encoding no input data analysis This mode is recommended if you want to encode binary input data WWW TEC IT COM Page 58 of 73 10 11 3 Error Correction Level Defines the error correction level DENE Lowest level Default Data recovery capacity is approximately up to 8 EEE Highest level Up to 30 Table 13 Han Xin Code Error Correction Levels 10 11 4 Mask Pattern Selects the mask pattern which is applied to the symbol matrix XOR masking The goal of the mask pattern is to distribute the bar space transitions evenly over the symbol in order to improve the readability of the barcode
40. arcode data check digit method barcode appearance etc to your needs There are three different methods for changing barcode parameters These methods are explained in section 6 3 Please keep in mind In order to select move resize edit and program the TBarCode control you have to be in Design Mode When leaving the design mode the control is locked and cannot be edited 6 2 Activate the Design Mode Application How to activate the Design Mode See section 6 2 1 Excel See section 6 2 2 InfoPath See section 9 2 6 2 1 Microsoft Word or Excel Mailings Review View Developer Add Ins Switch to Design Mode by clicking on the acl veunmon Sg ies ne triangle symbol in the Developer Ribbon H EH Fpl oerties ansformatio A T Group a SE Expansion Packs une Eating If this ribbon is not visible please refer to Controls XML Protect chapter 5 Design Mode Turn on or off design mode Press F1 for more help 6 2 2 Cut You can activate the Design Mode when opening ee ee the form or report om Open the desired form or report by Report View double click and choose Design View Be P from the menu a Print Preview A or ur Open Right click on the form report name and Layout View Layout View select Design View from the pop up lid Design View lt menu Export WWW TEC IT COM Page 19 of 73 6 3 Barcode Parameters The barcode parameters can b
41. d InfoPath Please refer to section 9 2 3 5 3 Microsoft Office 2007 Access 5 3 1 Insert Barcode in Word 2007 You can also insert a barcode as follows Click the Office button on the top left of the Word window and then select Word Options WWW TEC IT COM Page 12 of 73 Enable the Developer tab in the Ribbon Change the most popular options in Word Display Proofing Top options for working with Word Show Mini Toolbar on selection i Enable Live Preview i Save Advanced Always use Clearlype Open e mail attachments in Full Screen Reading view i Color scheme Blue Customize Add Ins Trust Center Then go to the Developer tab and click Legacy Tools More Controls Select TBarCode11 from the list of ActiveX Controls and confirm with OK The barcode will be inserted at the current cursor position DY H 9 ou Document3 Home Insert Page Layout References Mailings Rei Record Macro ll Pause Recording Visual Macros Basic AN Macro Security Code ActiveX Controls zE A iil a Ea Gas aie 5 3 2 Insert Barcode in Excel 2007 Enable the Developer tab in the Ribbon Excel Options Top options for working with Excel Show Mini Toolbar on selection Enable Live Preview en Show Developer tab in the Ribbon Always use ClearType Figure 3 Excel 2007 Excel Options Show Developer tab
42. d append Number of symbols A Z Indes of this symbol A Z Message ID optional Cancel Figure 30 Advanced Properties Aztec Code 10 7 1 Format Format Specifier You can choose from Default The standard format of Aztec Code UCC EAN Special format defined by UCC and EAN Used for encoding so called Application Identifiers FNC1 is added at first position Industry For special industry formats If you choose this value you have to fill in a Format Specifier 2 digits or 1 letter It determines which industry format the barcode data corresponds to FNC1 is inserted at second position 10 7 2 Symbol Size Defines the size of the Aztec Code symbol Possible values range from 1 15 x 15 to 33 151 x 151 modules If the property is set to default the size is computed automatically based on the length of the barcode data Additionally you can select one of three reader mode 19x19 reader 23x23 reader 27x27 reader These modes are often used to program the barcode scanners 10 7 3 Enforce binary encoding If checked binary mode is used for encoding no input data analysis This mode is recommended if you want to encode binary input data 10 7 4 Enable Aztec Runes The Aztec Runes mode is a special mode of the Aztec Code You can encode only values between 0 and 255 Aztec Runes can be displayed in a very compact way and are highly readable due to Reed Solomon error correction
43. d background color will be ignored ForeColor The foreground color of the barcode color of the bars TextColor The color of the human readable text QuietZoneColorLeft The color of the quiet zone left of the barcode If the back style is set to Transparent the adjusted color will be ignored QuietZoneColorBottom The color of the quiet zone below the barcode If the back style is set to Transparent the adjusted color will be ignored QuietZoneColorRight The color of the quiet zone right of the barcode If the back style is set to Transparent the adjusted color will be ignored WWW TEC IT COM Page 51 of 73 QuietZoneColoTop The color of the quiet zone above the barcode If the back style is set to Transparent the adjusted color will be ignored 10 5 2 Color Set You can choose between Standard Colors and Windows System Colors Each of these color sets offers a different color palette 10 5 3 Color Palette Clicking on one of the list entries assigns the color to the selected property 10 5 4 Edit Custom Color Clicking this button opens a dialog which lets you select a color for the list entry lt Custom gt Alternatively you can also double click on the lt Custom gt list entry 10 6 Adjust Depending on the selected barcode type TBarCode offers additional barcode specific adjustments You can access these adjustments by clicking on the Adjust button i
44. e las in Date 26 09 2006 Design This F orm Location 9 2 2 Add TBarCode to the Custom Controls To add TBarCode to the Custom Controls please follow the steps below Make sure that you are in Design Mode see 9 2 Open the Task Pane Therefore select View gt Task Pane from the menu see WWW TEC IT COM Page 28 of 73 Design Templatel Microsoft Office InfoPath 2003 gt File Edit vi i Format Tools Table H Type a question for help m aM A B Gl ps Design Tasks fl g I I ge se la AB et r Insert oe ees eee oe 44 Verdana DE Layout Fage Width Guid Insert areas in your form s view age Wi uide 7 1 Location to control layout SS SiS eS emailen een Reiner Se ee Se Rense nee nenne eei a Requested By i office Location EN Controls i eo Add controls to let users enter data into the form Phone Number ta Data Source Display and modify the form s data source Lal views Create views to define the appearance of form data Ha Publish Form Distribute the Form bo other users by publishing it in a shared location E mail Address Help with Design Tasks Figure 13 Add TBarCode to the Custom Controls in Microsoft InfoPath 2003 1 Inthe Task Pane click on Controls Then click on Add or Remove Custom Controls at the bottom of the updated pane view see A dialog will appear This dialog shows a l
45. e adjusted either by using the Property Pages the Property List or VBA Code Except for some special settings which are available in the property list or via code only TEC IT recommends the use of the property pages The property pages are designed for easy adjustment of the TBarCode properties 6 3 1 Property Pages Panis ee ee _ m Basic settings Barcode Type Symbology e yes Barcode Adjust Properties 1 Characters Advanced Settings Encoding Mode Convert to Code Page v Code Page Defaut v fo Format Subset V Default Check Digit Default z Compression None x Suppress Error Messages Translate Escape Sequences License About 2 Cut Adjust Properties Copy Paste Options Sg Properties gel View Code TearCodett Object Papers 2 8 Hyperlink License Format Control Convert Figure 9 Property Pages Microsoft Word Application How to open the Property Pages Make sure that you are in Design Mode see section 6 2 Right click on the TBarCode object Select TBarCode11 Object Properties from the pop up menu Access Access The property pages will appear InfoPath Make sure that you are in Design Mode Right click on the TBarCode object and select TBarCode11 Properties For detailed information about the property pages and about the available settings
46. ed as human readable text or not Default Yes 10 3 2 2 Above Symbol Prints the human readable text above the symbol default below gt For some barcodes like UPC and EAN the adjustment Above symbol is not permitted WWW TEC IT COM Page 47 of 73 10 3 2 3 Alignment Changes the alignment of the human readable text Value Description Default Uses the default text alignment Center Aligns the human readable text to the left Aligns the human readable text to the right Center Centers the human readable text Table 5 Text Alignment 10 3 2 4 Text Distance Allows you to specify the distance between the human readable text and the barcode in 1 1000 mm If Default is marked the minimum text distance is used Otherwise the given value will be added 10 3 3 Barcode Size and Module Width 10 3 3 1 Mode This option selects the calculation method for the barcode size Value Description Default Fit to bounding rectangle Draws the biggest possible barcode which fits into the bounding rectangle Resizing the bounding rectangle directly resizes the barcode Custom Specify module width Uses the specified module width for drawing the barcode see section 10 3 3 2 Minimal Optimize for readability Creates the smallest possible barcode for the selected R
47. egative way In special cases e g very small or high resolution barcodes you may want to test the pro duct without restrictions To obtain a temporary license key contact sales tec it com For enabling the full featured version without the demo hints you can obtain a license key from TEC IT http www tec it com order For more information on licensing TBarCode please refer to chapter 11 3 5 Important Security Notice Version 8 0 and newer versions include a fix which was implemented in response to a security leak a malicious web site in conjunction with Internet Explorer and an installed TBarCode ActiveX Up to now no real threat is known but it is strongly recommended to update all TBarCode installations as soon as possible For applications not supporting ActiveX technology you may use other TEC IT Barcode Tools e g Barcode Studio WWW TEC IT COM Page 9 of 73 4 Installation 4 1 Requirements The following operating systems are supported Microsoft Windows XP Microsoft Windows Server 2003 Microsoft Windows Vista Microsoft Windows Server 2008 Microsoft Windows 7 Microsoft Windows 8 Microsoft Windows Server 2012 TBarCode OCX was tested with the following Microsoft Office versions in particular with Microsoft Word Excel Access Visio and InfoPath Microsoft Office 2003 Microsoft Office 2007 Microsoft Office 2010 32 bit and 64 bit Microsoft Office 2012 32 bit and
48. ell Top CellLeft Range TargetCell Left Insert barcode object into selected cell Set BCObject ActiveSheet OLEObjects Add ClassType TBarCodell TBarCodell 1 Left CellLeft Top CellTo midti ce Tiwidthi T Height CellHeight Adjust the barcode object properties barcode type barcode data BCObject Object BarCode 20 T elect Code 2e nTa Code ITIL EBC Cede 25 BCOb veces Object Tees 123456 set barcode data BCObJeEct Ob ect FonrSize 3 set size of human readable text Via VBA code the barcode can only be inserted as OLE Object not as OLE Control WWW TEC IT COM Page 26 of 73 8 4 Adjust Barcode Parameters and Barcode Data Application How to Adjust Barcode Parameters Word See section 8 4 1 Excel Access See section 8 4 2 InfoPath No VBA supported 8 4 1 Microsoft Word or Excel The example below shows basic TBarCode method calls The barcode object is identified by the name TBarCode111 see section 8 2 TBar ode RBar odem ie ar ode Amer Bea Nora er tne par code type Dara Matriz TBarCodelll Text Hello World get the barcode data 8 4 2 Microsoft Access gt To access the barcode properties and methods you have to use the object interface The example below sets the barcode data text property of TBarCode The barcode object is identified by the name TBarCode111 see section 8 2 TBarCodelllsObject Text 1234567890 set the barcode data 8 5 L
49. equences Change Control Add or Remove Custom Controls Figure 23 Adjust Barcode Properties in Microsoft InfoPath 2010 WWW TEC IT COM Page 40 of 73 10 The Property Pages 10 1 Introduction The property pages of TBarCode and all settings which can be adjusted within the property pages are described in detail below See section 6 3 1 about opening the property pages 10 2 Property Page Barcode The first property page is the Barcode tab It contains basic barcode adjustments like Barcode Type Symbology Barcode Data etc For most applications adjusting these settings will be suffi cient Additional parameters can be changed on demand button Adjust tabs Appearance Multiple Barcodes Font and Color TBarCodell Properties Barcode LE Font Color r Bas c settings Barcode Type Sumbology Code 128 Barcode Adjust Properties 17 Characters q Advanced Settings Encoding Mode 6 Convert to Code Page Code Page Format Subset m Default Check Digit Default Compression None lied Suppress Error Messages Translate Escape Sequences Apply a m Figure 24 Property Page Barcode 10 2 1 Barcode Type Symbology Select the barcode type that you want to create Common linear barcode
50. er Message provide the additional data fields Service Class Country Code and Postal Code WWW TEC IT COM Page 60 of 73 These fields can also be specified by escape sequences in the Barcode data alias Text property For more information please refer to the Barcode Reference see Appendix A 10 12 5 1 Service class 0 999 Specifies the service class used with within the SCM mode 2 or 3 10 12 5 2 Country code 0 999 Specifies the country code used with within the SCM mode 2 or 3 10 12 5 3 Postal code 9 digits Specifies the postal code used with within the SCM mode 2 or 3 Mode 2 up to 9 digits can be specified Mode 3 up to 6 characters digits and uppercase letters can be specified 10 13 Adjust Properties PDF417 PDF417 divides data content into graphical rows and columns It is a so called stacked symbolo gy This property page allows you to change specific settings for PDF417 PDF417 Truncated and MicroPDF symbologies PDF417 Properties NR r FDF417 Rows 3 90 MW Default Row height 1 1000 mm v Default Columns 1 30 i W Default Error correction level Default Encoding Mode Defaut r MicroPDF 41 7 Mode Default Yersiom Default auto select m Macro POF417 structured append Use Macro POF417 Segment index File ID alphanumeric File name Segment count 1 993393 Time stamp Sender
51. esolution see section 10 3 3 3 and for the selected Decoder type see section 10 3 3 5 Furthermore the module width of the barcode will be optimized for ensuring best readability Table 6 Size Mode Please note The size modes Custom and Minimal influence the horizontal size of a barcode only The barcode height is always given by the height of its bounding rectangle Only a few 2D barcodes like Data Matrix QR Code or Composite symbologies require a fixed width to height ratio For these barcodes the height will be calculated accordingly 10 3 3 2 Module Width 1 1000 mm lf the size mode is set to Custom Specify module width this input box lets you specify the size of one module in 1 1000 mm A module is the smallest element of a barcode The widths of all bars and spaces are multiples of one module width Sometimes the Module Width is also called Narrow Bar Width A constant module width is recommended if you have a varying amount of input data and if the optical data density should remain constant Furthermore some label specifications require a cons tant module width Please note When specifying a custom module width the barcode may grow bigger than the bounding rectangle for big module widths or for a large amount of input data Please make sure that the bounding rectangle is wide enough to display the whole barcode symbol To ensure that no regions of
52. he files TBar Code dll and the TBarCode ocx are located This is usually one of the TBarCode installation directory C Program Files Common Files TEC IT TBarCode 11 0 or C Program Files Common Files x86 TEC IT TBarCode 11 0 Then edit the ini file gt Please Note The ini file is loaded together with the TBarCode DLL All settings which were taken from the ini file may later be overridden per program code or via the property pages of every single TBarCode instance B 1 Compatible Draw Mode In order to use the Compatible draw mode as initial setting draw GDI rectangles instead of the de fault output method add the following line to the ini file DRAW MODE UseGDIRect 1 Possible Options are 1 and 0 Compatible draw mode enabled or disabled In Word Excel and other office applications all barcode settings are saved and restored as part of the document files Therefore the draw mode setting will have no effect when opening an existing document but only when inserting a new barcode However this setting will change the draw mode setting effectively in TBarCode applications like TBarCode for SAP TFORMer etc B 2 Site Lock OCX only The site lock is provided for security reasons It only applies to the TBarCode OCX when it is scripted within Internet Explorer With this option you can specify which sites are allowed to execute critical function calls on the control and which are not DOMAIN LIST
53. he following rules apply for data encoding a lf the base symbology requires a fixed number of input characters e g G51 DataB ar all input characters beyond the required amount will be encoded in the composite component automatically b lf the base symbology allows a vanable number of input characters the vertical bar character must be used to seperate the composite data from the base data 6S1 DataBar Expanded Stacked Segments per row W Default UF Cancel Figure 39 Advanced Properties Composite GS1 DataBar 10 16 1 Composite Component Sets the 2D composite component in order to generate an GS1 Composite Symbology Default None l Composite Symbologies are disabled Auto CC A B C Automatically choose CC A CC B or CC C type depending on the length of the input data CC A Use composite component A CC A CC A is a variant of the MicroPDF417 symbology with a unique combination of row address patterns RAP It is the smallest variant of the 2 dimensional composite component Up to 56 characters can be coded also alphanumeric with 3to 12 rows and 4 columns COB Use composite component B CC B CC B is a subset of the MicroPDF417 Symbol which is identified by the code word 920 CC B will be chosen automatically when CC A has not enough capacity in Auto mode CC B encodes up to 338 Char
54. he property Encoding Mode It is only considered if the encoding mode is setto Convert to Code Page You can choose among several pre defined code pages e g ANSI ISO 8559 1 Latin I UTF 8 Shift JIS or add the ID of a custom code page 10 2 6 Format Subset The format string is used for formatting the utilizable data of the barcode prior to encoding it The format string is built upon placeholders which can be combined with constant data characters to build the final data string Certain control characters make it possible to change the Subsets for Code 128 EAN 128 and UCC 128 or to define the desired start stop character of CODABAR For detailed information on format strings please refer to the Barcode Reference see Appendix A WWW TEC IT COM Page 42 of 73 10 2 7 Check Digit Here you can change the calculation method of the check digit Whether you need a check digit or not depends on your application and on the selected barcode type By default the appropriate check digit is selected automatically entry Default which means that the check digit is calculated according to the barcode specification Any other suitable calculation method can be selected via the combo box Why check digits In order to guarantee that the barcode data is read properly a check digit is inserted usually at the end of the utilizable data A comparison of the barcode content and the check digit informs the scanning device about the co
55. he scanner The error correction algorithm Reed Solomon has the following limit for a successful reconstruction of data total number of not decodable characters 2 number of read errors must be smaller than number of error correcting code words 2 WWW TEC IT COM Page 62 of 73 10 13 1 5Encoding Mode Choose the encoding mode of the barcode Normal Default Analyzes the input data Depending on the input data either text numeric or binary compaction mode is used in order to keep the resulting symbol as small as possible Binary Compaction Uses binary mode for encoding no input data analysis This mode is recommended if you want to encode binary input data 10 13 2 MicroPDF417 These settings apply for the MicroPDF417 symbology only 10 13 2 1 Mode Specifies how data is encoded when using Micro PDF417 In most cases the Default or the Binary mode is the best choice Some decoders may not support all modes listed here Please check with your scanner first vue Description Normal Default Analyzes the input data Depending on the input data either text numeric or binary compaction mode is used in order to keep the resulting symbol as small as possible UCC EAN 128 Emulation UCC EAN 128 emulation mode Transmit C1 or L3 Use compaction for Application Identifier Al 01 14 digits Code128 Emulation Code 128 emulation mode Transmit C
56. icense TBarCode Call the method LicenseMe from within your application Do this before barcodes are generated or printed Before calling this function the TBarCode OCX control must be instantiated otherwise an error message will be received To license TBarCode use the following VBA call TBarCodelll LicenseMe Licensee eLicKindDeveloper 1 LicenseKey eLicProd1D WWW TEC IT COM Page 27 of 73 9 Barcodes in Microsoft InfoPath 9 1 General In order to use TBarCode in Microsoft InfoPath you have to perform the following steps Open your form in Design Mode see section 9 2 Add TBarCode to the Custom Controls see section 9 2 2 This step is required only once It enables Microsoft InfoPath to use TBarCode During this step you have to specify the data source type for TBarCode You have to decide whether you want to encode the content of single data fields or the underlying InfoPath XML document or parts of the XML document Insert the barcode see section 9 2 3 Change the data binding optional see section 9 2 4 Adjust barcode parameters see section 9 2 5 9 2 InfoPath 2003 9 2 1 Activate the Design Mode Please note you have to be in Design Mode to add barcodes to a form design to select move resize and to adjust the barcode parameters You can activate the Design Mode by clicking on the triangle symbol in the Standard toolbar The design view will be opened in a separat
57. in Microsoft Access Add TBarCode to the Custom Controls in Microsoft InfoPath 2003 1 Add TBarCode to the Custom Controls in Microsoft InfoPath 2003 2 Add TBarCode to the Custom Controls in Microsoft InfoPath 2003 3 Insert TBarCode in a Microsoft InfoPath 2003 Document Adjust Barcode Properties in Microsoft InfoPath 2003 Add TBarCode to the Custom Controls in Microsoft InfoPath 2010 Add TBarCode to the Custom Controls in Microsoft InfoPath 2010 Add TBarCode to the Custom Controls in Microsoft InfoPath 2010 Add TBarCode to the Custom Controls in Microsoft InfoPath 2010 Insert TBarCode in a Microsoft InfoPath 2010 Document Adjust Barcode Properties in Microsoft InfoPath 2010 Property Page Barcode 4 2 3 4 Property Page Appearance Quiet Zone Adjustment Property Page Font Property Page Color Adjust Advanced Properties Aztec Code Advanced Properties Codablock F Advanced Properties Data Matrix Advanced Properties DotCode Advanced Properties Han Xin Code Advanced Properties MaxiCode Advanced Properties PDF417 Advanced Properties QR Code Advanced Properties Micro QR Code Advanced Properties Composite GS1 DataBar WWW TEC IT COM 11 12 13 14 14 16 17 17 20 21 23 24 29 30 32 33 34 35 35 36 38 39 40 41 45 47 50 51 52 53 54 55 57 58 59 61 64 66 67 Page 5 of 73 1 2 List of Tables Table 1 Compression Table 2 Compression Table 3
58. in the Design tab Controls section 5 Title Bi Page Numbers Logo Text Label Button 54 Date and Time Box BNO F al S abl Aa OONA Eg oil lo E Ative Controls ER e a Insert Activex Control WWW TEC IT COM Page 14 of 73 Select TBarCode11 from the list of ActiveX Controls and confirm with OK Insert ActiveX Control ev es Select an ActiveX Control Tabular Data Control a eS mbol Class TBarCode3 TBarCode4 TBarCode5S TBarCode6 TBarCode TBarCodes TBarCode9 TConnector2 TFormer41 TLicense Class Trimmer Class VideoRenderCtl Class Result Inserts a new TBarCode10 into your document A TBarCode control will be inserted For inserting barcodes in Microsoft Access 2003 use the TBarCode QuickStart manual provided in the Windows start menu 5 4 Microsoft Office 2010 Office 2013 5 4 1 Insert Barcode in Word 2010 Word 2013 Select File Options print sci sca Issues 7 Save amp Send Help Versions Ro A There are no previous versions of thi raed Exit Versions Go to the page Customize Ribbon and check the list entry Developer WWW TEC IT COM Page 15 of 73 P Word Options amp General 5 ustomize the Ribbon and keyboard shortcuts 5 Cust the
59. ing displayed In order to bind the barcode to a data source please execute the following steps Right click on the TBarCode object Select Properties from the pop up menu Select the Data tab For the property Control Source select the data field or the query that serves as source for the barcode content see This step is only possible if you have previously defined a data source for the report form You can do this by opening the properties dialog for the entire report WWW TEC IT COM Page 23 of 73 All ll 9 c Databasel Database Access 2007 2010 M Report Design Tools Dz File Home Create External Data Database Tools Design Arrange Format Page Setup A 1 A Themes f Group amp Sort Se fal Logo Fa 2 S w p 1 J colors 2 Totals L Title ae 9 View so Controls Insert Page Add Existing en ai Fonts fis Hide Details a Numbers 3 Date and Time Fields aie Views Themes Grouping amp Totals Controls Header Footer Tools All Access Ob Z Tablet X Property Sheet x Tg p ee ee ee eon ype Activex Control Tables A Page Header E tablet Format Data Event Other All O Reports A Control Source ID og Reporti OLE Class TBarCodeil Class TBarCode11 TBarlo Detail Enabled Yes ll ut ust Properties erties u Hl k Illl b Design View Num Lock A Efa wf
60. ist of installed custom controls Click the Add button to open the Add Custom Control Wizard Locate and select TBarCode11 in list then click Next On the following wizard pages you have to specify the data source type for TBarCode This selection determines how the barcode control can be used in InfoPath later on For more information please see below WWW TEC IT COM Page 29 of 73 Design Templatet Microsoft Office InfoPath 2003 Edit SH Insert Format Tools Table Help Type a question for help i Eile view Custom controls DE Layout Controls ii itt ah ac tii fa Data Source 3 see eee ee nn nn mn Rename Insert controls Add Custom Control Wizard Ed Advanced Select an Activex Control a Hyperlink You can select an Activex control that is installed on your computer and make it available in the Controls task pane As Expression Box es Select a control l vertical Label Sys Document lH Scrolling Region Sybase Web Datawindow OTC 10 0 SysColorCtrl class al Choice Group System Information Tabular Data Control al Repeating Choice Group an n A Choice Section TBarlodes TBarlode TLlonnectorz TeeChart ChartEditorPanel v5 heil Repeating Recursive Section Custom Details Automatically create data source III Language Language Neutral Add or Remove Custom Controls version 1 0 Crea se
61. l TBarCodeil Properties WWW TEC IT COM Page 39 of 73 9 3 4 Adjust Barcode Parameters The barcode parameters can be adjusted using the Property Pages a Property List is not avail able Please open the property pages as follows Right click on the barcode object Select TBarCode11 Properties from the pop up menu The property pages will appear For detailed information about the property pages and about the available settings please refer to chapter 10 4 wy es EG ee Ee Ue Design Forml Microsoft InfoPath Home Insert Page Design Data Developer Properties E Refresh Fields yE T From SharePoint List F l a x C3 EQ 4 i f gt D 4 Resource Files Eh From SharePoint Server m Web Data To ToSharePoint To Other Submit Form Form Rule User EJ Default Values alte 7 ei From Other Sources Connecions E mail Library Locations Options Load Submit Inspector Roles Form Data Get External Data Submit Form Rules Roles Controls TBarCodell Properties el Data barcode appearence font Gob See advanced Basic settings Barcode Type Symbology Code 128 X Adjust Demo Barcode Adjust Properties 1 Characters 4 Adjust Pl Eu Advanced Settings Encoding Mode Convert to Code Page Code Page Format Subset Default Split Cells Check Digit Borders and Shading a Compression Change Binding Suppress Error Messages Translate Escape S
62. like UPC and EAN the bearer bars must be set to None Value Description None Do not print bearer bars Top and Bottom Print bearer bars at the top and the bottom of the symbol Rectangle Print bearer bars on all 4 sides of the symbol For rectangular bearer bars the quiet zone see section 10 3 1 7 must be at least 12 times the module width Otherwise no bearer bars will be printed Top Print bearer bars at the top of the symbol Table 3 Bearer Bars Print bearer bars at the bottom of the symbol 10 3 1 6 Bearer Bar Width 1 1000 mm Sets the width of the bearer bars in 1 1000 mm Note If the bearer bar width is set to zero no bearer bars are printed 10 3 1 7 Draw Mode Due to problems with certain printer drivers TBarCode is able to use different methods to draw bar codes You can choose between following modes Value Default The bar codes are drawn in the advanced mode This provides the best quality Compatible The bar codes are drawn in the compatible mode This decreases the quality slightly but is supported by the most printers Dual The bar codes are drawn in the dual mode This is a combination of the Advanced and Compatible mode Table 4 Draw Mode WWW TEC IT COM Page 46 of 73 If you want to use the Compatible draw
63. lopers A DLL for Windows CE Windows Mobile is available on request Please contact us with your platform details 3 2 Scope of this Document This document concentrates on the use of TBarCode OCX in Microsoft Office applications In contrast to the other two components TBarCode NET TBarCode Library TBarCode OCX may be used without any programming knowledge This makes it easy to use and you will get results in quasi no time Using the OCX control you can integrate bar codes in text documents spreadsheets and the like First insert the barcode object in the desired document Then adjust the barcode properties barcode type data etc in the provided dialogs The first part of the document explains how to use TBarCode OCX in Office Applications like Word Excel Access and InfoPath A few simple examples also demonstrate the possibility of pro gramming the control in Visual Basic for Applications The second part of this document describes all available barcode properties which can be adjusted in the property dialogs All of these parameters are described in detail lf you are a software developer and if you are interested in integrating barcode features into your own applications please check out the accompanying developer manuals developer references and sample applications see Appendix A 3 3 What is TBarCode OCX TBarCode OCX is a Microsoft ActiveX compliant barcode control Such an ActiveX control is sometime
64. mbol is the last symbol in the chain the File ID which identifies one chain of symbols optional information WWW TEC IT COM Page 63 of 73 Filename Segment count Time stamp Sender Addressee File size Checksum CCITT 16 10 14 Adjust Properties QR Code QR Code 2005 The QR Code is a 2 dimensional matrix symbology like Data Matrix It has a remarkable data capacity of up to 3000 ASCII characters or 7000 digits The QR Code symbology was designed to read a lot of data within a minimum of time QR Code means Quick Response Code QR Code 2005 is a variant of QR Code which supports a default data encoding of Latin 1 instead of Kanji Japanese character set and is commonly used in Europe QR Code Properties nee r General Format application indicator Defaut J 1 2 digits 1 char Sumbol version size Default Error correction level Medium Mask pattern Default Compaction Default m Structured append Use structured append u Parity byte fo 0 255 Number of all symbols 2 16 j2 Index of this symbol 1 16 f Camel Figure 37 Advanced Properties QR Code 10 14 1 Format Application Indicator You can choose from Default The standard format of QR Code UCC EAN Special format defined by UCC and EAN Used for encoding so called Application Identifiers FNC1 is added at firs
65. mode as preferred setting you can specify this in an ini file For more information please refer to Appendix B 10 3 1 8 Quiet Zone The quiet zone is an empty area outside the barcode It helps the scanner to read the barcode correctly Clicking the Adjust button opens the following dialog Quiet Zone General Figure 26 Quiet Zone Adjustment In this dialog you adjust the quiet zone for all four sides of the barcode Possible units are Modules Millimeters Mils and Pixels Default No quiet zone is added For most 1D barcodes a quiet zone should be maintained directly before and after the barcode symbol As a rule of thumb the quiet zone should be ten times the dimension of the module width or at least 1 4 inch 6 5 mm The exact value depends on the selected barcode type Please note A few barcode types provide the required quiet zone automatically These bar codes are EAN 8 EAN 13 UPC A UPC E and ISBN Changing the quiet zone for these symbologies will add an additional white space 10 3 2 Text Options The text options allow the adjustment of the human readable text The human readable text is usually printed below the barcode symbol and shows the content of the barcode gt Not all barcode specifications support the printing of human readable text If human readable text is not supported the following setting will be ignored 10 3 2 1 Print Text Specifies whether the barcode data is print
66. n the Barcode tab This button is available for Aztec Code Codablock F Data Matrix DotCode Han Xin Code MaxiCode MicroPDF417 PDF417 PDF417 Truncated QR Code Micro QR Code and all Composite Symbologies TBarCodell Properties Barcode Appearance Fort Color Basic settings Barcode Type Symbologp TSE fi Adjust Barcode Adjust Properties 17 Characters Advanced Settings Encoding Mode Convert to Code Page tts Code Page Detaut jo Format Subset ss A W Default Check Digit Deft Compression Mons o Suppress Eror Messages Translate Escape Sequences License About Figure 29 Adjust The following sections 10 7 to 10 16 will give an overview over barcode specific properties gt Please take care when modifying these properties Some settings may result in unreadable barcodes Always make a test scan in case of doubt WWW TEC IT COM Page 52 of 73 10 7 Adjust Properties Aztec Code Aztec Code is a 2 dimensional Matrix Code Characteristic for the Aztec Code is the finder in the center of the symbol which contains of 3 to 5 lapping squares Aztec Code Properties u r General T SS 1 Format format specifier 2 digits 1 char Symbol size i a Enforce binary encoding Enable Aztec Runes Error correction in 0 30 z Structured append Use structure
67. n view and also edit this name by right clicking on the respective barcode symbol Then select Properties from the pop up menu The name of the control is shown in Properties TBarCode111 TBarCode 11 r Alphabetic Categorized gt To edit and to program the TBarCode control the design mode is required For accessing the control in your VBA code use the name as assigned in gt Hint If you double click the control in design mode the VBA editor is opened not shown gt Fora list of available properties and methods and for a detailed description of the TBarCode programming interface please refer to the developer documentation see Appendix A 8 3 Insert Barcode The following code samples can be used to create and to insert a barcode object in Office applica tions You can execute the code with a macro or you can trigger it with a control event e g button click Word InfoPath No VBA supported WWW TEC IT COM Page 25 of 73 8 3 1 Microsoft Word This sample shows how to insert a Code 128 symbol at the actual cursor position The barcode data will be set to 1234567890 Dim oShape As InlineShape Dam oOTBe As Object insert a shape containing a barcode object at the actual Cursor position Set oShape Selection InlineShapes AddOLEObject ClassType TBarCodell TBarCodell 1 FileName LinkToFile False DisplayAsIcon False Activate the barcode object oShape OLE
68. nce 10 3 3 Barcode Size and Module Width 10 3 3 1 Mode 10 3 3 2 Module Width 1 1000 mm 10 3 3 3 Resolution 10 3 3 4 Custom Resolution DPI 10 3 3 5 Decoder 10 3 4 Display Error if Barcode is clipped 10 4 Property Page Font 10 4 1 Properties 10 4 2 Font 10 4 3 Size 10 4 4 Effects 10 4 5 Sample Text 10 5 Property Page Color 10 5 1 Properties 10 5 2 Color Set 10 5 3 Color Palette 10 5 4 Edit Custom Color 10 6 Adjust 10 7 Adjust Properties Aztec Code 10 7 1 Format Format Specifier 10 7 2 Symbol Size 10 7 3 Enforce binary encoding 10 7 4 Enable Aztec Runes 10 7 5 Error Correction in 0 90 10 7 6 Structured Append 10 7 6 1 Use structured append 10 7 6 2 Number of all symbols A Z 10 7 6 3 Index of this symbol 1 16 10 7 6 4 Message ID 10 8 Adjust Properties Codablock F 10 8 1 Rows 2 44 10 8 2 Columns 4 62 10 8 3 Row height 1 1000 mm WWW TEC IT COM Page 3 of 73 10 8 4 10 8 5 10 9 10 9 1 10 9 2 10 9 3 10 9 4 10 9 5 Separator height 1 1000 mm Code format Adjust Properties Data Matrix Code Format Symbol Size Enforce Binary Encoding Show as Rectangle Structured Append 10 9 5 1 Use structured append 10 9 5 2 Number of all symbols 2 16 10 9 5 3 Index of this symbol 1 16 10 9 5 4 File ID 1 64516 10 10 10 10 1 10 10 2 10 10 3 10 10 4 10 10 5 10 10 6 10 10 7 Adjust Properties DotCode Format Format Specifier Size Mode Ratio
69. nformation contained therein Reproduction use or disclosure to third parties without express authority is strictly forbidden Fur dieses Dokument und den darin dargestellten Gegenstand behalten wir uns alle Rechte vor Vervielf ltigung Bekanntgabe an Dritte oder Verwendung au erhalb des vereinbarten Zweckes sind nicht gestattet 1998 2013 TEC IT Datenverarbeitung GmbH Hans Wagner Str 6 A 4400 Austria t 43 0 7252 72720 f 43 0 7252 72720 77 http www tec it com WWW TEC IT COM Page 7 0f 73 3 Introduction 3 1 What is TBarCode SDK TBarCode SDK is a set of professional tools for the generation of barcodes More than 100 different symbologies linear barcodes 2D barcodes and stacked barcode variants can be printed or exported as graphics files All industry formats are supported The barcodes can be generated in the highest possible resolution and quality TBarCode SDK is available in several versions for different operating systems applications and programming environments The following versions are included in this setup TBarCode OCX TBarCode NET TBarCode Library A Microsoft ActiveX compliant barcode control It can be used with Microsoft Office applications as well as by software developers A NET barcode library for software developers It includes barcode controls for Windows Forms and ASP NET 2 0 A DLL for Windows platforms for software deve
70. nstead of any error information 10 2 10 Translate Escape Sequences Selects whether escape sequences like n are translated or not default no The use of escape sequences is useful if you need to encode control characters such as Carriage Return or FNC1 For encoding binary data e g Data Matrix this feature may be very useful as well For more information on escape sequences please refer to the Barcode Reference see Appendix A 10 2 11 Button License Opens the license dialog For more information on how to license the product please refer to chapter 11 10 2 12 Button About Opens the about dialog The About dialog shows the product version and copyright information to the user WWW TEC IT COM Page 44 of 73 10 3 Property Page Appearance TBarCodell Properties Barcode Appearance Font Color r General Onentation co Print Ratio 2340234 I Default Back Style Bar Width Reduction amp 000 PM Default Bearer Bars Mone Bearer Bar width 1A1000 mm Ss Detaul Draw Mode Defaut Quiet one Adjust m Test options W Print Text Above Symbol Alignment Default ka Text Distance 11000 mm W Default Barcode Size and Module Width Mode Default Fit to bounding rectangle Module Width 1 1000 ram Resolution 300 dpi Poor print quality Custom Resolution dpi 300 0 Decoder Hardware decoder i Display Error if Barcode is Clipped
71. o Security Add ins Fy Mi Code Add Ins Legacy Forms abl i BEE a 2 ActiveX Controls LINTE EA ERS FR 5 4 2 Insert Barcode in Excel 2010 Excel 2013 Enable the Developer tab in the Ribbon File Options Customize Ribbon Editing Insert Fage Layout Formulas Data Add gt gt Review ha View lt lt Remove Developer Ey Add Ins Background Removal Figure 6 Excel 2010 Excel Options Show Developer tab WWW TEC IT COM Page 16 of 73 Go to the Developer tab and select Insert More Controls Properties F fe Map Properties _ gt view Code Expansi Expansion Packs De Source a Mode gj Run Dialog Wi Refresh Data More Controls Form Controls XML a HM sao Taxonomy Control Os 4a Ta activex Contos TBarcodett UmEvmControl Class 30 Aaz K VCMacroPicker Class More Controls ee a a Ann Insert a control from the set of Figure 8 Excel 2010 Select TBarCode11 controls available on this computer Figure 7 Excel 2010 More Controls Select TBarCode11 from the list of object types and confirm with OK Now move the mouse cursor to the desired position and draw a rectangle to the position where the bar code should be A TBarCode control will be inserted Please note In Word 2010 and Excel 2010 the Control Toolbox can be found in the Developer tab in Access 2010 inside the Design Tab 5 4 3 Insert Barcode in Access 2010 Access 2013 Open a
72. oe Eoo Please refer to the TBarCode OCX Developer Reference Introduction Security for more infor mation B 3 License TBarCode In order to license TBarCode you can paste your license data in the ini file If you want to know how to do this please contact our support mailto barcode tec it com WWW TEC IT COM Page 72 of 73 Appendix C FAQ The frequently asked questions are located on our web page http www tec it com FAQ f you do not find the required answers please feel free to contact our support team mailto barcode tec it com WWW TEC IT COM Page 73 of 73
73. pend If you want to connect several QR Code symbols for encoding larger quantities of data you can use structured append 10 14 6 1 Use Structured Append Activates structured append symbol chaining WWW TEC IT COM Page 65 of 73 10 14 6 2Parity Byte 0 255 Chained QR Code symbols are identified by the parity byte The parity byte must be identical in all symbols of a chain gt The value of the parity byte depends on the barcode data for the complete chain To calcu late its value you can use the method QRCode StructAppParity which is available in the ActiveX interface For more information about the ActiveX interface and its available methods please refer to the developer manual see Appendix A 10 14 6 3 Number of all Symbols 2 16 Enter the total number of chained QR Code symbols here A maximum of 16 symbols may be used within one chain 10 14 6 4 Index of this Symbol 1 16 A symbol identification number which is entered in the index field must be assigned to each QR Code symbol Its value can range from 1 to 16 This index indicates the order in which the data Is joined after the reading scanning process 10 15 Adjust Properties Micro QR Code The Micro QR Code is a small variant of the QR Code with a reduced number of overhead modules and a restricted range of sizes The maximum amount of data is 35 numeric 21 alphanumeric 15 byte or 9 Kanji characters in conjunction with the lowes
74. put h AaBbCcDc AaBbCcDd AaBbCcDd Gai Text Box 2 Rich Text Box ER Drop Down List Heading 2 Label Column L g Combo Box ri Check Box Option Button i Styles Eel Date Picker Date and Time Pi Multiple Selecti List Box Bulleted List Numbered List g Plain List Es Person Group Pi E External Item Pic Objects Button b l Picture Button fe Calculated Value i File Attachment Picture a Hyperlink ee ee ey Containers ol Section Optional Section IF Repeating Section Repeating Table lal Choice Group E Choice Section F Figure 18 Add TBarCode to the Custom Controls in Microsoft InfoPath 2010 1 To add TBarCode to the Custom Controls please follow the steps below Click on Controls Add or Remove Custom Controls A dialog will appear which shows a list of installed custom controls Click the Add button to open the Add Custom Control Wizard In Dialog Control Type choose ActiveX Control click Next Locate and select TBarCode11 in list then click Next x Controls that are not compatible with the current view compatibility settings will be hidden Custom controls PuuunmnnnunnnnnunnnnnununnnnunnEnmunnunn Em nunnmnnunn nn nunnnnnnunnEnmumnunnnmnunnmnnunnnmnunnnnnnunnunmunnunnnmnunnmununnnnnununnnnn Remove Rename Figure 19 Add TBarCode to the Custom Controls in Microsoft InfoPath 2010 2 WWW TEC IT COM Page 35 of 73 Add Custom
75. ration Navision is a registered trademark of Microsoft Business Solutions ApS in the United States and or other countries Oracle is a registered trademark of Oracle Corporation PCL is a registered trademark of the Hewlett Packard Company PostScript is a registered trademark of Adobe Systems Inc SAP SAP Logo R 2 R 3 ABAP and SAPscript are trademarks or registered trademarks of SAP AG in Germany and in several other countries Unicode is a trademark of Unicode Inc All other products mentioned are trademarks or registered trademarks of their respective companies If any trademark on our web site or in this document is not marked as trademark or registered trademark we ask you to send us a short message mailto office tec it com WWW TEC IT COM Page 70 of 73 Appendix A Related Downloads A 1 Developer Manuals For software developers TBarCode provides additional documents Developer Manuals Descriptions on how to use TBarCode in development environments IDEs like Microsoft Visual Studio Borland Delphi Borland C Builder Sybase Power Builder ASP NET and more Developer References Detailed descriptions of the TBarCode programming interface API with all methods properties enumerations and events These documents are included in the setup Start Menu TEC IT TBarCode 11 Developer Manuals A 2 Sample Applications TEC IT provides a number of sample applications which allow customers to sta
76. rn Compaction Adjust Properties Composite GS1 DataBar RSS Composite Component 10 16 1 1 Data Input for the GS1 Composite Symbology 10 16 2 Segments per Row WWW TEC IT COM Page 4 of 73 12 Appendix A 1 A 2 A 3 Licensing License Types Entering your License Data 11 2 1 License Dialog Contact and Support Information A Related Downloads Developer Manuals Sample Applications Barcode Reference Appendix B TBarCode INI File B 1 B 2 B 3 Compatible Draw Mode Site Lock OCX only License TBarCode Appendix C FAQ 1 1 List of Figures Figure 1 Insert Barcode using the Menu Microsoft Word Figure 2 Insert Barcode using the Control Toolbox Microsoft Word Figure 3 Excel 2007 Excel Options Show Developer tab Figure 4 Excel 2007 More Controls Figure 5 Excel 2007 Select TBarCode1 1 Figure 6 Excel 2010 Excel Options Show Developer tab Figure 7 Excel 2010 More Controls Figure 8 Excel 2010 Select TBarCode1 1 Figure 9 Property Pages Microsoft Word Figure 10 Figure 11 Figure 12 Figure 13 Figure 14 Figure 15 Figure 16 Figure 17 Figure 18 Figure 19 Figure 20 Figure 21 Figure 22 Figure 23 Figure 24 Figure 25 Figure 26 Figure 27 Figure 28 Figure 29 Figure 30 Figure 31 Figure 32 Figure 33 Figure 34 Figure 35 Figure 36 Figure 37 Figure 38 Figure 39 Property List Microsoft Word Data Binding in Microsoft Excel Data Binding
77. rrectness of the scan It causes the device to accept or to reject repeat the scan The check digit calculation method is standardized for certain common barcodes A change of the check digit method is admissible for special applications or for barcodes with selectable check digit methods only For some barcodes the standard is no check digit However using a check digit is recom mended e g LOGMARS or Code39 You can use the combo box for enabling check digit calculation 10 2 7 1 Check Digit Override Some barcodes with a predefined number of utilizable data characters like all EAN UPC Postnet and RSS 14 codes include a check digit on a fixed position in the barcode data Example The EAN13 code permits 12 utilizable digits plus 1 check digit at the last position O If you enter 12 digits as barcode data this last digit the check digit will be calculated and inserted automatically However you can also enter all 13 digits and therefore override the calculated check digit eLO Yoel gt Note If the check digit is supplied within the barcode data the internal check digit calcula tion will be switched off gt TBarCode does not check the correctness of the check digit supplied by your application Check digit override was primarily designed for use with article databases in which the check digit is already included in the article numbers However the check digit override can also be used to calculate
78. rsions In Office 2007 Office 2010 Office 2013 inserting the TBarCode control has slightly changed How to do this is explained in the sections 5 3 5 4 Insert Barcode in Microsoft Word 2007 2010 Insert Barcode in Microsoft Excel 2007 2010 Insert Barcode in Microsoft Access 2007 2010 Finally the usage of TBarCode in Microsoft InfoPath is explained in chapter 9 5 2 Microsoft Office 2003 5 2 1 Insert Barcode in Word 2003 using the Menu Document3 Microsoft Word ala File Edit view Insert Format Tools Table Window Help Type a question for help X Oad F Break wo ap EN a ME a EJHA 7 110 HRe B Aq Normal Page Numbers English U S B Z x x EZ Z zj i Borders and Shading A n Date and Time New Barcode E Help License About E AutoText BREIT 1 3 F 15 AS a kia 118 A El Field Object x ca ee Fi symbol Create New Create from File N J Comment A a i Object type T Reference Package hay Es RegwizCtrl Web Lon ponent u Snapshot File T System Monitor Control Sl Picture g 3a Diagram TConnector2 C Display as icon L TFormer4 p z Text Box Yideo Clip Result nc Inserts a new TBarCode9 object into your document m J i o z Adjust Properties a Figure 1 Insert Barcode using the Menu Microsoft Word WWW TEC IT COM Page 11 of 73 Excel Select TBarCode 1
79. rt with the develop ment of their own applications and or documents as fast as possible Sample applications are included in the TBarCode11 setup Start Menu TEC IT TBarCode 11 Examples or can be downloaded from the TEC IT web site http www tec it com download area Make sure TBarCode was installed before trying to run any sample application A 3 Barcode Reference The document Barcode Reference provides an overview over supported barcode types and gives additional information on how to use them The following issues are discussed Supported Barcode Symbologies with detailed information on each barcode type Check Digits general information and available check digits methods Print Ratio and Ratio Hints or Ratio Format Format Strings Escape Sequences and Control Characters Application Identifiers MaxiCode and UPS standards And more The Barcode Reference is available as separate document on the TEC IT web site http www tec it com gt Support gt Knowledge Base The direct URL is as follows http www tec it com download PDF Barcode Reference EN pdf WWW TEC IT COM Page 71 of 73 Appendix B TBarCode INI File For TBarCode you can specify an ini file which allows you to do the following tasks Preset the Draw Mode to Compatible Apply a Site Lock OCX only License TBarCode First create a text file named barcode ini and put the file in the same directory where t
80. s called OLE control or OCX control In German it is named Steuerelement You can use TBarCode OCX in Microsoft Office barcodes are embedded into documents forms or databases easily Development environments integrate barcodes into your own application s Report Generators and Reporting Engines Enhance the output with barcode functionality Web Applications Use barcode technique as part of browser based applications WWW TEC IT COM Page 8 of 73 Most programming and script languages Examples where you can use TBarCode OCX for barcode generation Microsoft Word Microsoft ASP VBScript Borland Quick Reports Microsoft Excel Microsoft Internet Explorer Sybase PowerBuilder Microsoft Access Microsoft Visual FoxPro Crystal Reports 8 Microsoft InfoPath Microsoft Dynamics Nav ActiveReports Data Dynamics Microsoft SharePoint Navision Financials IBM Object REXX Microsoft Visio PHP 4 x PHP 5 x Alpha Five Database XBasic Microsoft Visual Basic Borland C Builder ASNA Visual RPG Microsoft Visual C Borland Delphi And a lot of more applications 3 4 Restrictions of the Demo Version In the demo version the barcodes will be drawn with a demo hint That means that the word Demo or the phrase www tec it com is drawn partially over the barcode The demo hint does not influ ence the readability of the barcode in a n
81. s the error correction level Values between 0 and 8 are allowed The error correction level defines the number of code words which are used for error recognition correction Each PDF417 barcode contains at least two code words Level 0 2 code words Level 1 4 code words Level 2 8 code words And so on Levels 3 to 7 are using 16 32 64 128 and 256 code words Level 8 uses 512 code words for error correction Value Description Depending on the amount of input data the error correction level is set to a value between 2 and 5 automatically Error recognition only no error correction is possible 2 code words are used for calculating a check sum Error correction 4 code words are used for error correction information Error correction 8 code words are used for error correction information Error correction 512 code words are used for error correction information Table 16 PDF417 Error Correction Levels A higher error correction level adds more redundant information to the symbol Therefore the symbol will require more space for printing If the symbol is distorted through surface damage bad printing quality or dirt the error correction information can help to reconstruct the full infor mation contained in the PDF symbol reconstruction is done by t
82. sign Template Microsoft Office InfoPath 2003 File Edit view Insert Format Tools Table Help 5 led E Preview Form JA 7 a A Add or Remove Custom Controls Custom contrals Remove Rename Figure 15 Add TBarCode to the Custom Controls in Microsoft InfoPath 2003 3 WWW TEC IT COM Baa Type a question for help DE Layout Se Controls a Data Source Lal views Insert controls a Hyperlink As Expression Box WS Vertical Label LE Scrolling Region el Choice Group al Repeating Choice Group E Choice Section heil Repeating Recursive Sech n Custom ll TBarlode Automatically create data source Add or Remove Custom Controls Help with Controls Page 32 of 73 9 2 3 Insert Barcode After you added TBarCode OCX to the Custom Controls in Microsoft InfoPath see section 9 2 2 you can add a barcode to your document by performing the following steps Place the cursor where you want to insert the barcode and click on the TBarCode control in the Task Pane Before the barcode is actually inserted a dialog named TBarCode11 Binding appears Select the required field lt or group 4 as data source see The content of the selected entry will be encoded as barcode Please note If you have selected single data fields as data source type see 9 2 2 1 1 you can select fields only no groups Press OK A new barcode object will be inserted File
83. t CODABLOCK F Properties el Rows 2 44 Default Columns 4 62 JM Default Row height 1 1000 mm Default Separator height 1 1000 min Default Code format Default Lancel Figure 31 Advanced Properties Codablock F 10 8 1 Rows 2 44 Specifies the number of rows used for encoding The value must be between 2 and 44 Default the number of lines is calculated automatically depending on the number of input characters 10 8 2 Columns 4 62 Defines the number of columns of the generated bar code The value must be between 4 and 62 Start stop and line indicator columns as well as code subset selectors are not taken into account WWW TEC IT COM Page 54 of 73 Default the number of columns is calculated automatically depending on the number of input characters 10 8 3 Row height 1 1000 mm Sets the height of an individual row in 1 1000 mm Default The row height is calculated automati cally 10 8 4 Separator height 1 1000 mm Sets the height of the row separator in 1 1000 mm Default The height of the separator is calcu lated automatically 10 8 5 Code format You can choose one of the following formats Default Standard format UCC EAN Special format defined by UCC and EAN to be used in UCC EAN applications Used for encoding so called Application Identifiers Als A FNC1 is encoded at first position automatically Table 9 Codablock F Code Formats 10 9 Adjust
84. t error correction level OR Code Properties General Format application Indicator If a 2 digits 1 char Symbol version size Defaut O X Error correction level Medium Mask pattern Defaut l Compaction Defaut Structured append Use structured append Parity byte 0 255 Number of all symbols 2 16 Index ofthis symbol 1 18 Cancel Figure 38 Advanced Properties Micro QR Code 10 15 1 Symbol Version Size The Micro QR Code has four different symbol sizes M1 M4 The smallest version size M1 is restricted to numeric data and error detection M2 may contain alphanumeric values M3 and M4 may use the whole range of the QR Code character sets bytes Kanji 10 15 2 Error Correction Level Defines the error correction level See QR Code section 10 14 3 WWW TEC IT COM Page 66 of 73 10 15 3 Mask Pattern Sets the mask pattern See QR Code section 10 14 4 Note The Micro QR Code has only 4 mask patterns and not 8 like the QR Code 10 15 4 Compaction Defines the compaction mode See QR Code section 10 14 5 10 16 Adjust Properties Composite GS1 DataBar RSS In this menu you can adjust the parameters for the GS1 Composite Symbology and for the GS1 DataBar Expanded Stacked symbology Composite G451 DataBar R35 Properties G51 Composite symbology Composite component Default None IF Composite Sumbology is enabled t
85. t position Industry For special industry formats If you choose this value you have to fill in an Application Indicator 2 digits or 1 letter It determines which industry format the barcode data corresponds to FNC1 is inserted at second position Table 18 QR Code Formats 10 14 2 Symbol Version Size Defines the version size of the QR Code symbol Possible values range from 1 27 x 21 to 40 177 x 177 modules If the property is set to default the size is computed automatically based on the length of the barcode data WWW TEC IT COM Page 64 of 73 10 14 3 Error Correction Level Defines the error correction level Value Description L ow Lowest level Data recovery capacity is approximately up to 7 M edium Up to 15 Q uartil Up to 25 H igh Highest level Up to 30 Table 19 QR Code Error Correction Levels 10 14 4 Mask Pattern Selects the mask pattern which is applied to the barcode symbol XOR masking The goal of the mask pattern is to distribute the bar space transitions evenly over the symbol in order to improve the readability of the barcode Default Selects the mask pattern automatically recommended 0 7 Selects one of the mask patterns 0 to 7 manually Manual selection may be useful if you want to generate many symbols within minimal computa tion time The algorithm for identifying the optimal mask automatically is complex and resource consuming However the readabili
86. te Then select all data types by clicking each single line in Leave the default data type as Text string Then click Finish 9 3 1 1 2 Encode Complete or Partial Form Content XML Data Perform these steps if you plan to encode XML data Bind an ActiveX control property to a field in the data source of the form template this allows data associated with the control to be saved Binding property TextPositionLeft TextPositionTop TextRotation a WWW TEC IT COM Select the binding property Value see Click Next On the next page Specify and Enable or Disable Property select the entry Enabled Click Next Page 37 of 73 In select Field or Group any data type Deine a daia ype for the Activex onc Then click Finish Field or group type Field or Group any data type A This control can be bound to a field or group of any data type 9 3 1 2 Finish Adding the Custom Control After you have completed the wizard the TBarCode control will be listed in Click OK TBarCode11 appears in the list of available controls H oO we a F Design Forma Microsoft InfoPath E p File Home Insert Fage Design Data Developer oy B X Calibri Ay fabl Text Box 25 Rich Text Box E 34 f 5a B SF AaBbCcDd Aa Bb Drop Down List IM Combo Box r h Faste BE Normal Title Add Manage Editing Preview 2 F i Check Box
87. the barcode are clipped you can enable the option Display error if barcode is clipped see section 10 3 4 WWW TEC IT COM Page 48 of 73 10 3 3 3 Resolution The size mode Minimal Optimize for readability requires the Resolution of the printer scanner to be selected As value select the lowest resolution which is used within the chain of barcode processing printing scanning Additionally you have to select the decoding solution from the Decoder combo box below So it can be guaranteed that the printed barcode will be readable for the selected configuration Examples If the barcode is printed with 600 dpi and then scanned with a hardware scanner the resolution should be set to 600 dpi Good print quality As decoder select Hardware If the barcode is printed with 600 dpi transmitted with a fax device 200 dpi and then scanned with a hardware scanner the resolution should be set to 200 dpi Fax As decoder select Hardware fthe barcode is printed with a laser printer 600 dpi and if it is then scanned with a flatbed scanner 150 dpi and then decoded via software you should select a custom resolution of 150 dpi As decoder select Software Value Description 96 dpi Screen Specifies the default screen resolution 200 dpi Fax Specifies the defa
88. tio of the barcode symbol WWW TEC IT COM Page 68 of 73 11 Licensing 11 1 License Types Please check out http www tec it com order for available license types and pricing Single licenses are bound to exactly one machine If you are interested in a single license please tell us the so called System ID of the target computer You can find the System ID in the licensing dialog see below 11 2 Entering your License Data After receiving your license data enter it in the license dialog You can also pass the license information via program code software developers see section 8 5 gt Please enter the license data exactly as you received it from TEC IT Spacing and upper lower case letters are significant To avoid typographical errors please insert the data using copy and paste from the email containing your license data whenever possible 11 2 1 License Dialog For entering the license data right click on the inserted TBarCode object and select TBarCode Object License from the pop up menu The following dialog will appear License Information TBarCode 10 ees This is the System ID of your Computer System ID lt p Product TBarCode 2D incl 2D symbologies Under Product select the product that you have ee Emo VERSION purchased You can select elle A TBarCode 1D standard TBarCode 2D incl 2D symbologies Humber of licenses Tour license key In the
89. ty of the barcode may suffer when using manual selection Table 20 QR Code Mask Patterns 10 14 5 Compaction QR Code can compact dedicated Multi Byte character sets from 16 bit representation into 13 bit en coding This property enables the compaction of Kanji or Simplified Chinese characters into 13 bit values ActiveX controls are using the Unicode character set Depending on the Code Page property the Unicode input is converted to the corresponding encoding If you use one of the available compaction modes please make sure that the Unicode input is converted to either Shift JIS X 0208 Kanji or GB2312 Simplified Chinese Also make sure that your decoder scanner can deal with these compaction modes Value Description Default Default multi byte character compression Depends on specified Code Page None No multi byte character compression Kanji compaction Enables Kanji character compaction Input data must be supplied in Multi Byte character set Shift JIS X 0208 see Code Page Compaction of Kanji characters is done according to ISO IEC 18004 and AIM ITS 97 001 specification Chinese compaction Enables Chinese character compaction Input data must be supplied in Multi Byte character set GB2312 see Code Page Compaction of Chinese characters is done according to GB T 18284 2000 Please note that this compaction mode is not supported by all decoders Table 21 QR Code Compaction Modes 10 14 6 Structured Ap
90. types are UPC USA EAN Europe Code 128 Code 39 2 of 5 Interleaved Common 2D barcode types are Data Matrix PDF417 and QR Code For information on the different barcode types symbologies please refer to the Barcode Refe rence see Appendix A 10 2 2 Button Adjust The Adjust button will open a barcode specific properties dialog for the selected barcode type symbology This button is available for 2D barcodes and for composite symbologies only Barcode specific settings are described in sections 10 6 to 10 16 WWW TEC IT COM Page 41 of 73 10 2 3 Barcode Data The content of this textbox will be encoded as barcode Depending on the selected barcode type you can encode different kinds of data Some barcodes can be used to encode digits only Others allow the usage of digits and a limited number of special characters like P or Again others can be used to encode arbitrary alphanumeric data For more information on barcode types and on codeable data please refer to the Barcode Refe rence see Appendix A The number of letters that the data currently contains is shown below Barcode Data Ifthe Barcode Data cannot be represented with the selected symbology a big X is drawn instead of the barcode Additionally an error code and a short error description are displayed 10 2 4 Encoding Mode The Encoding Mode specifies how the input data should be interpreted Data
91. ult fax resolution 202 dpi Thermo transfer This resolution is used by thermo transfer printers e g by Zebra printers 300 dpi Poor print quality Specifies a low printer resolution _ 600 dpi Good print quality Specifies the standard printer resolution Custom dpi Specifies any other resolution The dpi value can be entered in the input box on the right see section 10 3 3 4 Table 7 Resolution 10 3 3 4 Custom Resolution DPI Specifies the custom dpi value for the size mode Minimal Optimize for readability if Resolution is set to Custom dpi 10 3 3 5 Decoder Specifies which kind of decoder is used for reading the barcode content size mode Minimal Optimize for readability Value Description Both Hardware and Software Select this option if you do not know which type of barcode decoder will be used Based on the adjusted resolution see section 10 3 3 4 TBarCode OCX will automati cally choose a barcode size which can be read with both decoder types Software and Hardware If you are unsure about the resolution we recommend a setting of 200 dpi This should be readable in most cases Hardware Select this option if the barcode is scanned and decoded via a scanning device e g handheld scanner This setting guarantees a minimal module width of 0 254 mm for linear barcodes and 0 5 mm for
92. w and confirm Page 33 of 73 9 2 5 Adjust Barcode Parameters The barcode parameters can be adjusted using the Property Pages a Property List is not avail able Please open the property pages as follows Right click on the barcode object Select TBarCode11 Properties from the pop up menu The property pages will appear For detailed information about the property pages and about the available settings please refer to chapter 10 Design Template Microsoft Office InfoPath 2003 EES File Edt wiew Insert Format Tools Table Help Type a question for help b za y Preview Form FE fe on A ES iF om A Aa bf Design Tasks ied wl Controls Request Number Barcode type symbology Code1 28 Adjust More Details Barcode data Adjust Properties Change Binding L o 2a Show Data Source Contact Informa Requested By Advanced settings Phone Number paca Eormat Subset W Default Check digit Defaut Compression None h Suppress error messages License About woh Description Figure 17 Adjust Barcode Properties in Microsoft InfoPath 2003 Translate escape sequences 9 3 InfoPath 2010 InfoPath 2013 Open InfoPath Designer in order to perform the steps described below Open a form that can be filled with InfoPath Filler WWW TEC IT COM Page 34 of 73 9 3 1 Add TBarCode to the Custom Controls In
93. y Text see Click Next On the next page Specify and Enable or Disable Property select the entry Enabled Click Next In select Field element or attribute Then select all data types by clicking each single line in Leave the default data type as Text string Then click Finish 9 2 2 1 2 Encode Complete or Partial Form Content XML Data Perform these steps if you plan to encode XML data Add Custom Control Wizard Specify a Binding Property Bind an Actives control property to a Field in the form s data source this allows data associated with the control to be saved Binding property Quality QuietZone Ratio Ratiobefault RatisHint RSS SegmPerRow SizeMode SuppressErrorflsg Text Textalignment TextColor TextDistance eine WWW TEC IT COM Select the binding property Value see Click Next On the next page Specify and Enable or Disable Property select the entry Enabled Click Next Page 31 of 73 Add Custom Control Wizard Specify Data Type Options Define a data type For the Activex control Field or group type aee e ham slg pate E 9 2 2 2 Finish Adding the Custom Control In select Field or Group any data type Then click Finish After you have completed the wizard the TBarCode control will be listed in Click OK TBarCode11 appears in the list of available controls De

Download Pdf Manuals

image

Related Search

Related Contents

Oxus POC Manual - Vitality Medical  Briggs & Stratton 592 User's Manual  Programação Orientada a Objeto em C++  取扱説明書 - mugenseiki.com / .co.jp  TimeClockWizard User Manual  Fostex PD-2 User's Manual  - SkyLark  

Copyright © All rights reserved.
Failed to retrieve file