Access 2000 to VB .Net

[Louis Bourbeau]

Hi,
I have a Access 2000 application that I want to transfer to Visual Basic
..Net. I was wondering how I could take my Access 2000 forms, modules and
reports and "migrate" them toward Visual Basic .Net forms, modules and
reports.

Is there a utility built-in access that can help me? Or maybe in Visual
Basic? Otherwise, I've been fiddling with Access2000 to get all the forms
contained in Access2K project. So far, I've managed to get the name of form
but afterward I need to get the information within the form more accuratly
the properties of the form and every element in it ( stuff like a button,
textbox,...).
Here's my code :

Function GetForm()
Dim obj As AccessObject
Dim objApp As Object
Set objApp = Application.CurrentProject

For Each obj In objApp.AllForms
msgbox obj.Name
Next obj
End Function

Thanks....

L. Bourbeau

 

[chas]

Hi Louis,

There are large differences between VB 6 and VB .NET that
make converting VB apps a problem, and there are even
greater differences with Access/VBA to .NET. I am not
aware of any utilities out there yet that can do this.

- unless someone else knows better

hth

chas

 

[Louis Bourbeau]

Thanks Chas,

I've found an application but it doesn't seem to be working right. So I
decided to do it myself. So far, I've managed to get all the properties of
my form and the code behind it. Now I'm need to know what's the information
in the .frm files for Visual Basic .Net 2003 and I'll be able to finish my
converter.

If you're interested just let me know.

L.Bourbeau

 

[Rebecca Riordan]

VB.Net doesn't use .frm files. Forms are stored in .vb files, which are in
effect class declarations. I'd suggest manually creating one of your forms
in VB.Net and then looking at the source code...it should be pretty clear
what needs to happen, although I should think it's a non-trivial exercise.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...