Access Converter™ Java Edition

Supported Features

Version 3.1

Copyright 2000-2009 Diamond Edge, Inc.

We are constantly adding support for more of the features of the Visual Basic language and libraries. We are committed to having the highest quality and most accurate Access to Java conversion tool available on the market. Any features you would like supported or any problems you notice should be emailed to . Snippets of code would be greatly appreciated and expedite the process of improving the conversion process.

Environment

• Generated code will run as a stand-alone application or as an applet.
• Uses 1.1 event style.
• Uses Java 2 swing controls
• Generated Java code is readable and easily recognizable to Access programmer.
• Generates 2 different coding styles.
• Indent amount is definable.
• Mapping between Access and Java controls are defined in user customizable conversion rule files so mapping can be changed to use any Java controls including a company's own custom library.
• Mappings for functions and constants are defined in user customizable conversion rule files. Must purchase a Library Source License to get the source to the conversion rule files.
• Users can add support for 3rd party controls by writing a conversion rule file.

Visual Basic Language

Statements Data Types Miscellaneous Constants Operators Functions DoCmd Statement App Object Clipboard Object Collection Object Form Object MDIForm Object Screen Object

Access and ActiveX Controls

CheckBox Control ComboBox Control CommandButton Control Image Control Label Control Line Control ListBox Control OptionButton Control OptionGroup Control Rectangle Control TextBox Control RichTextBox Control MaskEdBox Control SpinButton Control SSTab Control SSCheck Control SSCommand Control SSFrame Control SSOption Control SSPanel Control SSRibbon Control

CommonDialog Control ProgressBar Control ImageList Control ListImage Object ListImages Object TabStrip Control Tabs Object Tab Object Toolbar Control Buttons Object Button Object StatusBar Control Panels Object Panel Object Slider Control Animation Control UpDown Control FlatScrollBar Control

Database Objects

ADO Objects Connection Object Recordset Object Fields Object Field Object Command Object Parameters Object Parameter Object Properties Object Error Object

DAO Objects DBEngine Object Connection Object Database Object Recordset Object Fields Object Field Object Parameters Object Parameter Object

Other Objects

Scripting Objects Dictionary Object FileSystemObject Object Drive Object Drives Object Folder Object Folders Object File Object Files Object TextStream Object Encoder Object

MSXML Objects DOMDocument Object IXMLDOMNodeList Object IXMLDOMNamedNodeMap Object IXMLDOMNode Object IXMLDOMDocumentType Object IXMLDOMElement Object IXMLDOMAttribute Object IXMLDOMDocumentFragment Object IXMLDOMText Object IXMLDOMCharacterData Object IXMLDOMComment Object IXMLDOMCDATASection Object IXMLDOMProcessingInstruction Object IXMLDOMEntityReference Object IXMLDOMNotation Object IXMLDOMEntity Object IXMLDOMParseError Object IXMLDOMImplementation Object

Optional Controls

DBGrid Control DataGrid Control Column Control Columns Object MSFlexGrid Control VsFlexGrid Control Grid Control Janus GridEX Control Farpoint Spread Control

TreeView Control Nodes Object Node Object Outline Control ListView Control ListItems Object ListItem Object ColumnHeaders Object ColumnHeader Object ListSubItems Object ListSubItem Object SSListBar Control Winsock Control

Note: Datasheet views are converted into a DataGrid in Java and thus requires this suite.

Conversion Guidelines

• Continuous Forms are not supported.
• Calculated fields where the ControlSource begins with an '=' are not supported.
• If you are using a variant and did not use one of the conversion routines when you are using a variant someplace that another type is expected, Java cannot automatically coerce the Variant to the right type. You must call one of the toInt, toDouble, toDate, or toString functions on the Variant to access the value.
• The static modifier on functions.
• The construct, On Error Goto label must conform to a particular style to be converted. The error handler must be at the end of the function. The following is the only flow that is supported for "On Error GoTo label" statement.

  Sub doit()
    ...
    On Error GoTo handle_error
    ...
    Exit Sub
  handle_error:
    ...
  End Sub
  

• Must set user.timezone property for the Now, Date, Time, functions to have the date and time in the correct timezone. Otherwise, it will always be returned using the GMT timezone. You can set it by:
• java -Duser.timezone=MST MyApp
• With statement does not support using the .<property> in all places. These may be flagged as errors. If you get an error when using the . operator then just expand the expression completely. For example:

  With Text1
  	.Text = "hello"  ' OK
  	Call MySub .Text ' not supported. Need to change to "MySub Text1.Text"
  End With

• File IO
  Only text files are supported. Open "file" For Random or Binary is not supported.
• If you are passing a control as an argument to a function be sure to specify the exact type and not just Control. Otherwise, you will not be able to access the properties specific to that type of control. For example:

  Sub Foo( text As Control )

  Should be:

  Sub Foo( text As TextBox )