VB to Access form

[Peter Kinsman]

To save a lengthy reinvention of the wheel, does anyone have a program to
convert a VB form into an access form please.

About six years ago, I wrote a VB6 program to convert an AS/400 screen
format into a VB6 form. Once I found that Access was much easier to
distribute than VB6, I modified the program to create an Access form. I
would need to look in the VB form that I was converting for what I had
output in the first of my programs and then do the corresponding action from
the second program.

This is why on this occasion I would rather pick someone else's brains if
possible.

Many thanks

Peter Kinsman

 

[Pat Hartman]

Since most of the programming world doesn't consider Access to be a "real"
development tool, you are very unlikely to find someone who bothered to
create a tool to convert something else to it. I've only come across a
couple of examples that go from Access to VB. If you look at the source
code for the VB form, you may be able to extract large portions of it and
paste it into the Access form. The one big gotcha that I know about is the
use of the .text property. VBA uses it differently so if you see .text in
VB, either remove the property entirely or change it to .Value.