:: Subscribe to our newsletter
 
Articles / Directory
02/10/2012
Latest version of TraderCode(v5.5) includes new Technical Analysis indicators, Point-and-Figure Charting and Strategy Backtesting.



1/04/2011
InvestmentCode, a comprehensive suite of
Financial calculators and models for Excel is now available.



9/01/2009
Launch of
Free Investment and Financial Calculator for Excel.



1/02/2009
Launch of NeuralCode(v1.0) for
Neural Networks Trading.



8/06/2008
Launch of ConnectCode Excel Training Courses. Get this
Free Excel Training (over 100 pages) now.



7/23/2008
ConnectCode Text Manager - add-in that enhances your productivity when working with text in Excel.



6/17/2008
ConnectCode Number Manager - add-in that enhances your productivity when working with numbers in Excel.



6/3/2008
ConnectCode Barcode Font Pack - enables barcodes in office applications and includes an add-in for Excel that supports mass generation of barcodes.



2/1/2008
Release of
SparkCode Professional - add-in for creating Dashboards in Excel with sparklines



12/15/2007
Announcing
ConnectCode Duplicate Remover - a powerful add-in for finding and removing duplicates entries in Excel



09/08/2007
Launch of
TinyGraphs - add in for creating sparklines and tiny charts in Excel.

Using ConnectCode with MS Access



Importing the Macros to Access

A sample MS Access database (ConnectCode.mdb) is included with the software installation package. This sample database includes the macros for generating the check digits, formatting the barcode string and adding start/stop characters in the "ConnectCode" module. This sample database is created for you to test out the creation of barcodes in Access quickly and easily.

Displaying a barcode in Access Reports

  1. Launch MS Access
  2. Open the ConnectCode.mdb database file (located at the /Resource directory)
  3. Under the Objects column, click on Reports
  4. Click on the SampleReport. This will bring up the report in Preview mode.






  5. Open the Report in Design View and search for the text "=Encode_Code39([Data])". This is the part which uses the ConnectCode formulas to encode data to a barcode string.
  6. Change the Font of this object to any of the ConnectCode Code39 Fonts. e.g. CCode39_S3. Resize the object to obtain the desired dimensions.
  7. Click on Print Preview to display the Report again
Importing ConnectCode Formulas into MS Access

If you will like to use your own database, you can do the following to import the macros.
  1. Launch Microsoft Access
  2. Click on the menu Tools->Macro->Visual Basic Editor.
  3. Click on the menu File->Import File...
  4. Select the Encoder.bas file that is bundled with ConnectCode. This file is located in the /Resource sub directory of where ConnectCode is installed
  5. Click on Save followed by Close in the Visual Basic Editor





 

Copyright (c) 2007-2015, ConnectCode Pte Ltd. All Rights Reserved.


Trademark Acknowledgements

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. All other product names are trademarks, registered trademarks, or service marks of their respective owners