ACCESS-TO-VB6 CONVERSION SOFTWARE? 2

[Hiccup]

Anyone out there know where I can get a software utility to convert Microsoft Access 2000 to VB 6.0?

I've heard it exists, but I surfed the Web and haven't been able to find it.

Appreciate any suggestions,

Ed "Hiccup" Hicks
ed.hicks@wcg.com

 

[randysmid]

Ed,
If you don't find any software that will do this, can you reply back to this message? I am asking because there is a manual technique on how to do this. Here is a few tips that will get you started.
First, you can copy all the code for a single form at one time, and then paste into VB6 for the same form. Just be sure that your controls have the same name (e.g., cmdStart, lstCompany, etc.)

Second, if possible, can you continue to save your data in the Access database? If this data is in Access 97 (A97), then you can use the standard data controls in VB6.

Third, VB6 does NOT have a decent report writer, but you can still connect to Access and run reports.

I am sure that I will more comments and suggestions about this, but why don't we wait and see if anyone knows of any conversion tools, ok? HTH,
Randy Smith
California Teachers Association

 

[MichaelRed]

To 'continue' the thought, it is not at all hard to write simple routines which list the 'important' properties of hte controls on a / ach form. With some (small) understanding of VB Form Files (.FRM), it would be quite a reasonable task to simply itterate through the MS. A. Forms Documents and generate a reasonable starting point of a VB form file. (Hint: ALL VB files are, at their most basic level, just text files. The first few lines are some 'header information' which identifies the VB version (weird, but even VB6 forms say VB5 here) and some special syntax for the form name. Following the header, is just a series of "With" blocks for each control, listing the NON-Standard properties in the standard '.property = value' format. After the controls' ".With" blocks, the Form Module is simnply listed as text. The only 'tricky' part would be to devine any specific controls and/or their properties which are not represented in VB, and find SOME manner of dealing with them. It MIGHT also be desireable to set up the default properties of the controls to not list, but this would really just be a convenience.



MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[randysmid]

Michael,
Your last post was really valuable. It certainly deserves a star for your insight into all of this.
Randy HTH,
Randy Smith
California Teachers Association