Hi,

Does anyone know of any freeware tool that might help in this? I
have looked at a couple commercial access to vb conversion tools but
they are pretty expensive so I am wondering if anyone knows of a
freeware or open source tool that we could use to save us some time and
effort.....

Thanks,

Malakie

Tony Toews lists a few tools at
http://www.granite.ab.ca/access/accesstovb.htm: I'm not aware whether any of
them are free.

The general consensus is that conversion tools do an incomplete job at best.
There are simply too many differences between the controls available for
forms in VB and in Access. You should be able to reuse most of the VBA code
(a simply copy-and-paste), but you'll likely have to rebuild the forms.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Malakie" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi,
>
> Does anyone know of any freeware tool that might help in this? I
> have looked at a couple commercial access to vb conversion tools but they
> are pretty expensive so I am wondering if anyone knows of a freeware or
> open source tool that we could use to save us some time and effort.....
>
> Thanks,
>
> Malakie

Douglas J. Steele wrote:
> Tony Toews lists a few tools at
> http://www.granite.ab.ca/access/accesstovb.htm: I'm not aware whether any of
> them are free.
>
> The general consensus is that conversion tools do an incomplete job at best.
> There are simply too many differences between the controls available for
> forms in VB and in Access. You should be able to reuse most of the VBA code
> (a simply copy-and-paste), but you'll likely have to rebuild the forms.
>


Hi,

I realize the conversion tools will not do a 100% job.. However with
such a large project, they would definitely help cut time even if it is
only the layout of user interface screens that are usable.

Thanks

Malakie