|
|
| Providing barcode tutorials, plug-ins, FAQs, integration and printing solutions for Microsoft Access, Excel, Word, FrontPage and other Office applications. | |
|
|
|
|
Reseller and Affiliate programs |
IDAutomation's ActiveX Controls are easy to use "drag and drop" plug-ins for Microsoft® Access, Excel, Word, FrontPage and other MS Office applications. The ActiveX Controls support several linear and two dimensional barcode symbologies including Code 39, Code 128, Interleaved 2 of 5, LOGMARS, Extended Code 39, GS1-128, Codabar, UPC-A, UPC-E, MSI, EAN-8, EAN-13, USPS OneCode, POSTNET, PDF417, Data Matrix and others. Using the control is a simple 3-step process as described below:
|
|
| Installation | ||
|
||
| MS Word Installation | ||
In Microsoft Word, choose View - Toolbars - Control Toolbox. In the toolbox, choose the more controls button:
Select the barcode control from the list of available ActiveX Controls. After selecting it, the control will appear in the document, the control may be sized as necessary. To change the properties of the control such as barcode height and symbology type, right click on the control and choose Properties. When finished, exit the design mode by choosing the design mode button:
To edit the properties of the control the program must be in design mode.
If there are problems editing the properties of the control, press the design
mode button to enable it. |
||
| MS Access Installation | ||
In a Microsoft Access report in design mode, choose Insert - ActiveX control. Size the control as necessary. To change the properties of the control such as barcode height and symbology type, right click on the control and choose Properties. To bind the control to a data source, enter the table and field or formula
in the control source field. The proper barcode will show up after the report
is saved. |
||
| MS Excel Installation | ||
In Microsoft® Excel, choose View - Toolbars - Control Toolbox. In the toolbox, choose the more controls button:
Select the barcode control from the list of available ActiveX Controls. After selecting it, click and drag an area for the control to appear in the spreadsheet, size the control as necessary. To change the properties of the control such as barcode height and symbology type, right click on the control and choose Properties. When finished, exit design mode by choosing the design mode button:
To edit the properties of the control the program must be in design mode.
If there are problems editing the properties of the control, press the design
mode button to enable it. To link a cell to the data to be encoded in the
barcode, enter the cell in the "LinkedCell" property of the control. |
||
| MS FrontPage Installation | ||
In Microsoft FrontPage, choose Insert - Advanced - ActiveX Control. The control will then appear in the web page. The control must be installed on every PC that accesses the web page that displays the ActiveX control and the control will only work with Internet Explorer. |
||
| Step 3 - adjust the properties of the control | ||
After
the control is inserted in an application as described in
Step 2,
the properties of the control can now be adjusted. To do this, right click
on the control and choose Properties.
This section explains the main configuration parameters of the control: NOTE: Many of the barcode sizing parameters are calculated in cm (centimeters). To convert inches to cm, multiply the value in inches by 2.54. To convert mils to cm, multiply the mils value by .00254.
Symbology specific notes UPC-A, UPC-E, EAN-8 and EAN-13 Enter the data to be encoded without any spaces or dashes. Enter the +2 and +5 add-on codes by just adding them to the end of the string. If the check digit is added, it will be ignored and regenerated to ensure that the code can be scanned. If the barcode is rotated by 270, the top margin may need to be increased. For UPC-E, enter the full 11 or 12 digit UPC-A code and the barcode will be compressed if possible. POSTNET and PLANET When using the POSTNET barcode, the NarrowBarWidth of .045 cm should be used. For barcodes to be acceptable to the US post offices, they must be between 22 and 24 bars per inch. Setting the NarrowBarWidth to .045 should produce about 23 bars per inch. This setting should be adjusted for the printer if the results are different. UCC/EAN Code 128 This symbology option adds in the FNC1 function
and formats the output to print using Code 128. Use this function for UCC/EAN-128
applications when the MOD10 check digit has already been generated. Supports
UCC-128, EAN-128, SSCC-18 and SCC-14. The FNC1 code is automatically included
after the start digit; "ÊÊ" may also be entered between even numbers for
additional FNC1 codes. For example, to encode an SSCC-18 barcode, enter
00000123455555555558 as the data input. |
||
| Notes for programmers | ||
If the control needs to be distributed with an application or manually, then the control will have to be copied to the "System" directory of the destination PC, then type "REGSVR32 IDAutomationLinear.dll" at the prompt. This process can be automated with installation utilities. When distributing the control with an application, make sure to choose the option to register it. Below is a sample of a SETUP.LST file used by the Visual Basic package and deployment wizard. NOTE: Distribution of IDAutomation products outside an organization requires a Developer License. [Setup1 Files] IDAutomation's ActiveX Controls are packaged by the Setup Generator Pro application. In the Setup Generator Pro application, choose the "Register as OCX or DLL" option for the IDAutomationLinear.dll file. This is an easy-to-use, yet powerful application that does not have any runtime requirements like the Visual Basic package and deployment wizard does, and it costs less than $100. IDAutomation recommends using this setup application if the intent is to distribute the control to other PCs and a setup application is not readily available. Order a copy of this setup application. Technical support To obtain technical support for IDAutomation controls, please visit the
ActiveX Control
Technical Support Site. |
|
© Copyright 2000-2009 IDAutomation.com, Inc., All Rights Reserved. Legal Notices. |
|
Over 70% of Fortune 100 companies use IDAutomation's products to automate their businesses. |