[RESOLVED] Calling VB6 from Access XP

Here is my unique (may be not!) situation.

We are upgrading one of our applications (finally) from Access XP to VB6 ( :mad: ) in a phased approach. The first one is converting reports in Crystal and viewing those reports in VB6 (using Crystal APIs). The second part is fine - calling Crystal APIs from VB6. But now how do I call this VB6 form from MS Access?

The users will click on a section of the screen in Access XP and that should open up the VB6 form (which will display the list of reports - and VB6 portion works fine). Should I create a different kind of VB6 project (DLLs or AddIns etc)?

Thank You!

Could u not use the shell command to open your vb app?

In a module in the VBA IDE...

VB Code:

Option Compare Database
 
Private Sub ExecuteMe()
    Shell "C:\Test.exe", vbNormalFocus
End Sub

:thumb:

Thank you guys! I was expecting something like creating a COM but the SHELL sounds good too - ahh me - how could I not think about SHELL!

I noticed you added the resolved checkmark to your last post. If you consider this resolved, would you please pull down the Thread Tools menu and click the Mark Thread Resolved menu item? That will let everyone know that you have your answer.

Thank you. :)