Can't open data control in MS Visual Basic Editor for MS project
The forms and controls used in VB are different to those used in
VBA (the
cut-down version of VB used in Office apps). They are simply not
interchangeable. Some controls work in both, but many don't; and the
form-handling itself is different also. Sadly, you have to pick your development
and environment and stick to it. And yes, it's deliberate: VBA has enough
functionality that Microsoft could boast about it for marketing purposes, but
not enough for serious development -- for that you have to buy VB also.
One work around is to do all the coding and forms in VB and either:
a) create a reference to Project from within VB, and call the methods etc from
your VB code, or
b) compile your VB code to a DLL, add that as a reference to your VBA project,
and call your projects methods (which can include displaying a form) from your
VBA code.
Quote:
> Hi,
> I created a form that displays an Access database in Visual Basic 6.0,
> the stand alone application. But I can't seem to open the form in the
> Visual Basic Editor for MS project. Hence, I tried creating the form
> again in the Editor but it does not support the "Data control". Is
> this deliberate? Or is there a way to get around it?
> Bonsang
