Converting VB6 to Access VBA

D

DS

Hi does anyone know anything converting a VB6 applet into a Access VBA
project? Tips, tricks converters anything of the sort?
Thanks
DS
 
D

Douglas J. Steele

Sorry, but that's a little too vague a question.

It all depends on your VB6 app. If you used 3rd party controls and stuff,
it's probably a big deal, as many ActiveX controls that work with VB6 won't
work with Access. On the other hand, if it uses basic functionality in the
forms, you may be able to copy all of the VB code into modules in Access,
and simply rebuild the forms.
 
D

DS

Douglas said:
Sorry, but that's a little too vague a question.

It all depends on your VB6 app. If you used 3rd party controls and stuff,
it's probably a big deal, as many ActiveX controls that work with VB6 won't
work with Access. On the other hand, if it uses basic functionality in the
forms, you may be able to copy all of the VB code into modules in Access,
and simply rebuild the forms.
Click to expand...
Thank you Doug, It's just basic stuff.
DS
 
L

Larry Linson

Thank you Doug, It's just basic stuff.
Click to expand...

The problem with "basic stuff" can be that much of the code we write in
either VB or Access VBA is accessing / manipulating the object model, and
the VB and Access object models are quite different.

If you have standard modules that are not manipulating the object model,
those can likely be transferred without change to VBA (copy and paste). But
you will still have to re-create forms, and the code that goes with the
forms and manipulates the forms and the controls -- which will require lots
of changes.

Larry Linson
Microsoft Access MVP
 
Top