Results 1 to 5 of 5

Thread: [RESOLVED] Calling VB6 from Access XP

  1. #1

    Thread Starter
    Member
    Join Date
    Jul 2005
    Posts
    36

    Resolved [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 ( ) 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!
    Last edited by Hack; May 1st, 2006 at 09:52 AM. Reason: Added [RESOLVED] to thread title and green "resolved" checkmark
    A Will Will Find A Way

  2. #2
    Member Mythrandil's Avatar
    Join Date
    Mar 2006
    Posts
    55

    Re: Calling VB6 from Access XP

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

  3. #3
    Super Moderator RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,713

    Re: Calling VB6 from Access XP

    In a module in the VBA IDE...
    VB Code:
    1. Option Compare Database
    2.  
    3. Private Sub ExecuteMe()
    4.     Shell "C:\Test.exe", vbNormalFocus
    5. End Sub
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  4. #4

    Thread Starter
    Member
    Join Date
    Jul 2005
    Posts
    36

    Resolved Re: Calling VB6 from Access XP

    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!
    A Will Will Find A Way

  5. #5
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,335

    Re: Calling VB6 from Access XP

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width