	  	---------------------------------------------------
	  	  Access 2002 to Visual Basic 6 Object Converter
		           	Evaluation Version 5.0
           	                     April 2001
	  	---------------------------------------------------
	  		   Copyright (C) IrieSoftware, 2001
	  		         All rights reserved
            		    Developed by Lennox Chambers
 			     http://www.iriesoftware.com

Note: If you are using the Windows Notepad, select Word Wrap from the Edit menu.  

Thank you for evaluating the Access 10 to Visual Basic 6 Object Converter program.


Contents
--------
About Object Converter
Object Converter Setup
   References
Converting the Sample Databases
   AddrBook 
   Contacts
   Inventry
   Northwind 2000
   Northwind 2002
   Tab Controls
   Subform Controls
Copyright/License/Warranty
   License Agreement
   Governing Law
   Disclaimer of Warranty
Distributing Object Converter
Ordering Information
   Ordering by Credit Card
   Ordering by Cheque or Money Order
   Shipping
   Site Licenses
Order Form


About Object Converter:
-----------------------
This is an evaluation version for demonstration purposes only.

Object Converter is a Microsoft Access 2002 Add-In utility that rapidly converts Access 2000/2002 Queries, Forms and Code, Controls (including a number of ActiveX Custom Controls like the Microsoft Windows Common Controls and the Common Dialog Control), Macros, Reports, Code and Class Modules to Visual Basic Forms and Projects. 
 
Object Converter saves a great deal of time when porting selected Queries, Forms, Reports, Macros and Code Modules, or entire Access applications to Visual Basic.  There is no need to copy and paste code from Access to Visual Basic and re-design Forms from scratch.  Converted Forms and Code will run immediately or with minimal modifications in either the Visual Basic version 5.0 or 6.0 development environments.  

Converting all Forms in the Access 2002 Northwind sample database for example should take less than 1 minute to complete, depending on the speed of your computer.


Object Converter Setup:
-----------------------
To setup the Object Converter Add-in

1. Copy the OBJCONV22E.MDE database to your ACCESS 2002 directory
2. Open one of the Access sample databases
3. From the Tools menu, select Add-Ins then select the Add-In Manager command
4. Add a new Add-In using the OBJCONV22E.MDE database
5. Close the Add-in dialog window
6. A new Add-In menu item called Object Converter 2002 Eval will display on the Add-Ins sub-menu.
7. Click the Object Converter 2002 Eval menu item 
8. All the objects from the sample database will display in the Object Converter
9. You are now ready to convert your Access Objects to Visual Basic

Note: You can copy the files to any directory you like, as long as you are comfortable with editing your Registration database file located in the Windows directory.  

NOTE: This is not recommended.  It is highly recommended that the Access Add-in Manager be used to install the Object Converter program.
	
Start the RegEdit utility and edit the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Access\10.0\Menu Add-Ins\&Object Converter Library entry to point to the path and directory where the OBJCONV22E.MDE database file is located.


References:
-----------
If you receive a Timer Error() - Open Form action was canceled error, you need to check that all the required References to ActiveX controls (OCX files) and Dynamic Link Libraries (DLL files) in the database that you are trying to convert are selected.

In the database that you have opened to convert your objects, please ensure that you have the following list of References selected.  You can display the References by opening a form in code view and selecting References from the tools menu.  Here are the References to select in order of priority ...

Reference				File Name	
----------------------------------------------------
Visual Basic for Applications			VBE6.DLL	
Microsoft Access 10.0 Object Library		MSACC.OLB	
OLE Automation 					STDOLE2.TLB 	
Microsoft DAO Object Library 3.6		DAO360.DLL	
Microsoft Office 10.0 Object Library		MSO.DLL	
Microsoft Windows Common Controls 5.0 (SP2)	COMCTL32.OCX	
Microsoft Common Dialog Controls 6.0 (SP3)	COMDLG32.OCX	
Microsoft Tabbed Dialog Control 6.0 (SP4)	TABCTL32.OCX	

The following 3 References are optional and may be selected but are not necessary

Microsoft ActiveX Data Objects 2.1		MSADO21.TLB
Microsoft Visual Basic for Applications 
   Extensibility 5.3				VBE6EXT.OLB
Microsoft Office Web Components 10.0		OWC10.DLL

If any of the above files do not display in References you can...

1. Use the Browse button to locate the file on your hard drive, or 
2. Select ActiveX Controls from the Tools menu and Register the controls.  

The References are also available for download from the IrieSoftware website at http://www.iriesoftware.com.  Use the following Access 2002 code to check your References.  

Sub ChkRefs()
   Dim ref As Reference
   
   For Each ref In References
      Debug.Print ref.FullPath & " - " & ref.Name
   Next
End Sub

Open one of the Access Sample databases and open a Module in Code view.  Select the View/Immediate Window menu command and paste the ChkRefs() procedure into the Module.  In the Immediate window, type ChkRefs and press Enter.

The output should be similar to the following (your directory paths may differ)

C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL - VBA
D:\Office10\msacc.olb - Access
C:\WINDOWS\SYSTEM\stdole2.tlb - stdole
C:\PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\DAO\DAO360.DLL - DAO
C:\Program Files\Common Files\Microsoft Shared\Office10\MSO.DLL - Office
C:\WINDOWS\SYSTEM\COMCTL32.OCX - ComctlLib
C:\WINDOWS\SYSTEM\COMDLG32.OCX - MSComDlg
C:\WINDOWS\SYSTEM\TABCTL32.OCX - TabDlg

Optional References

C:\PROGRAM FILES\COMMON FILES\SYSTEM\ADO\msado21.tlb
C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB - VBIDE
C:\Program Files\Common Files\Microsoft Shared\Web Components\10\OWC10.DLL - OWC10

Should you have any difficulties installing or using the program, please email IrieSoftware at...

			support@iriesoftware.com
			lenx@home.com or
		        lennoxchambers@hotmail.com
		        

			
			Converting the Sample Databases
			-------------------------------

When converting the Access 2002 Sample databases, some forms will not convert correctly, may not load into Visual Basic, or after loading successfully will cause Visual Basic to crash (i.e., produce a General Protection Fault or an Illegal Operation error) when opened.
  
Visual Basic will not load a form that contains duplicate control names, and if it does load, when an attempt is made to open the form, Visual Basic will crash.  The generated .log file will display the line number and description of the error.  To resolve the problem, first rename the controls either in the Subform or in the main form in Access, or rename the controls in the converted VB .frm file.  

Refer to the Object Converter online Help for additional information on using the program.

AddrBook 
-----------
The Access 2002 AddrBook.mdb sample database converts all Objects without errors.

Contacts
--------
The Contacts form when converted will not open correctly in Visual Basic because it contains 3 Subforms named CallListSub, ctlCompany and Shipping Information with controls that have the same names as those on the form.  A Contacts.log error file will be generated.

The duplicate controls are Notes, Label0, Label1, Label2, Label3, Label4, Label5, Label6 and Label7.  The control Label2 occurs 3 times.  To fix the errors, rename the controls in the Contacts.frm file in order.  For example to fix the Notes TextBox control...

1. Open the Contacts.frm file and search for Notes.  
2. Skip the first Notes found in the Tab Control description
3. Search again and rename the next Notes found to Notes1.  
3. Search again and skip the first Notes TextBox name found
4. Search again and rename the next Notes TextBox Name to Notes1.  

Rename the Label0 control as Label0a and rename each of the other duplicate Label controls (Label1 through Label7). The Label2 control must be renamed twice, i.e., to Label2a, Label2b.


Inventry
--------
The Access 2000 Inventry.mdb sample database Converts all Objects without errors.


Northwind 2000
--------------
The Access 2000 Northwind.mdb sample database converts all Objects without errors.


Northwind 2002
--------------
The Access 2002 Northwind.mdb sample database converts all Objects without errors.

Tab Controls
------------
Converted Access Tab Controls when opened in Visual Basic may appear small.  To make the Tab Control appear its normal size, simply select and resize it slightly.

Subform Controls
----------------
Access Subform Controls are converted to Access Grid Controls if the Access DefaultView property is set to DataSheet or Continuous Form.  When a Subform control that is converted as a Grid Control is opened in visual Basic it may appear small.  To make the SubForm Control appear its normal size, select and resize it slightly.


			Copyright/License/Warranty
			--------------------------

License Agreement
-----------------
Please read the following terms and conditions before using this software.  Use of this software indicates your acceptance of this license agreement and warranty.  For information on distributing the shareware evaluation version of the Object Converter see the section titled Shareware License.


Governing Law
-------------
The laws of the province of British Columbia and the countries of Canada and the United States of America shall govern this agreement.


Disclaimer of Warranty
----------------------
The Object Converter and this README file are for use as is and without warranties as to performance or any other warranties whether expressed or implied. Because of the various hardware and software environments that the Object Converter may be used, no warranty for use is offered.

All programs should be thoroughly tested with non-critical data before relying on it. The user assumes the entire risk of using the program.  Any liability of the seller will be limited exclusively to product replacement or refund of purchase price.


Distributing Object Converter
-----------------------------
Unregistered use of the Object Converter without prior consent is in violation of Canadian, U.S. and International copyright laws.

Provided that you verify that you are distributing the Evaluation Version, you are hereby licensed to make as many copies of the Object Converter and documentation as you wish.  You may give exact copies of the original version to anyone, and distribute this version of the software and documentation in its unmodified form. 

You are specifically prohibited from charging, or requesting donations for any copies, however made, and from distributing the software and or documentation with other products (commercial or otherwise) without prior written permission, no exceptions.



			Ordering Information
			--------------------

Ordering by Credit Card
-----------------------
Order the Object Converter on the Internet using secure online credit card transactions.  Visit the IrieSoftware website at...

			http://www.iriesoftware.com


Ordering by Cheque or Money Order 
---------------------------------
Send the order form below, and a cheque or money order made payable to...
			
			Lennox Chambers 
			
			c/o IrieSoftware
			#61 - 10111 Swinton Cres.
			Richmond, BC
			V7A 3S9
			Canada

Payment must be in US dollars drawn on a US bank, or you can send international postal money orders in US dollars.


Shipping (Email is much faster)
-------------------------------
Object Converter is shipped on 3.5-inch disks only. Prices include shipping by postal mail (airmail outside USA) and are guaranteed through December 2001.  Please allow 4 to 6 weeks for delivery.


Site licenses
-------------
A site license for Object Converter entitles an organization to receive one copy of the software program and the right to duplicate the distribution disk for the specified number of copies.

			
			---------------------------------
			  Access 2002 to Visual Basic 6
			        Object Converter

				   Order Form
			---------------------------------

Date: ___________				Order #: _1_

            Name: __________________________________________
         Company: __________________________________________
         Address: __________________________________________
     City, State: __________________________________________
 Zip/Postal Code: __________________________________________
         Country: __________________________________________
  E-Mail address: __________________________________________


----- Number of ------
Computers	Copies	Price/each
-------------------------------------------------------------
Single Copy   	______  $ 149.95 = ___________
Upgrade			$  79.95 = ___________
(Must provide original order number)

		Site License
2 to   9 	______ 	$ 129.95 = ___________
10 to  24	______	$ 109.95 = ___________
25 to  49 	______ 	$  99.95 = ___________
50 to  99 	______ 	$  79.95 = ___________
100 to 199 	______ 	$  59.95 = ___________

                  Total payment  $ ___________


Feedback:




			------- Thank You -------
			
			     Lennox Chambers
			       IrieSoftware
			http://www.iriesoftware.com
