call VB.NET Form from Access VBA module

[bobk544]

Hello, my users want me to create a WORD status report application using XML
and they are currently using and Access database with VB/VBA modules for all
of their forms and processes.

Because i'm really only proficient in VB.NET & C#.NET and because i already
have WORDML processes ready on those platforms, can i somehow allow them to
select a button on one of their VB/WORD Access forms and bring up my VB.NET
Form and then jump back to their Access Form when done?

Thanks very much for any insights!
BobK

 

[Stefan Hoffmann]

hi Bob,

Hello, my users want me to create a WORD status report application using XML
and they are currently using and Access database with VB/VBA modules for all
of their forms and processes.

So why don't you export only the data in XML and apply your XSLT
transformation to generate the Word document?

Because i'm really only proficient in VB.NET & C#.NET and because i already
have WORDML processes ready on those platforms, can i somehow allow them to
select a button on one of their VB/WORD Access forms and bring up my VB.NET
Form and then jump back to their Access Form when done?

Basically you "only" need to make your classes COM visible:

http://support.microsoft.com/kb/817248



mfG
--> stefan <--

 

[jeremie sapac]

je parle francais

 

[bobk544]

Ok thanks Stefan, ok great, so you've seen where you can link to a .NET FORM
from VB or VBA and after interacting with a VB.NET form, you can link back to
the VB/VBA module...great that's what i wanted to know before digging into
one of these references..super!

and thanks for responding also "jeremie", even though i took 5 years of
French i can now only remember "mais non certainment non" in response!
hahaahahaha