VBA to Access form

[Hans-Christian Francke]

I have some forms made in VBA. Would it be possible to convert these forms
to regular Access forms?


--

Thank for any help.

Kindest regards
HC Francke

 

[Cheryl Fischer]

VBA (Visual Basic for Applications) is the code used in Access, so I am not
completely sure of the meaning of your question.

If you mean that your forms were created using Visual Basic (a part of
Microsoft Visual Studio, and a separate product from MS Access), then no,
these are not convertible. The functionality of forms and controls in MS
Access is so different from forms and controls in Visual Basic that any
conversion would do little good, for you would spend almost as much time
tweaking the converted forms and controls to make them truly functional in
MS Access as you would in creating them anew.

hth,

 

[Hans-Christian Francke]

When you open the Access project you will see both Access objects and VBA
forms. I have made a few forms from within VBA but since they don't have any
hWnd and other window properties I want to convert them to regular Access
forms so I can manipulate them as a window.

 

[TC]

There is really no such thing as a "VBA form". Forms are Access things, not
VBA things. You can use VBA to create a form, but the form is still an
Access thing, not a VBA thing.

HTH,
TC

 

[Hans-Christian Francke]

The forms are made using MSForms. I was confused about VBA making a separate
collection of the forms.

 

[TC]

OK, >now< I get it!

AFAIK, MS Forms are not supported in Access. People sometimes try to
reference the Forms 2 DLL, and get them going like that, but it never works
properly, AFAIK.

So you'll have to re-implement your MS Forms as Access forms + VBA.

HTH,
TC