Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2006

    Unanswered: Opening a .mdb file from another .mdb file

    I have designed some simple Access applications for my company. I would like to create a simple access application that allows users to use any one of the applications I created from, say a combo box in a form. How can I open another access application from a seperate access application? Someone pls help!!!

  2. #2
    Join Date
    Feb 2004
    One Flump in One Place
    Hi Neoman

    Welcome to the forum

    Some simple access automation (obviously you can change it to suit your needs):
    Public Function fAccAutomation() As Boolean
        Dim oAcc As Access.Application
        Set oAcc = New Access.Application
        oAcc.OpenCurrentDatabase "C:\test.mdb", False
        oAcc.Visible = True
        oAcc.DoCmd.OpenForm "form1"
        fAccAutomation = True
        Set oAcc = Nothing
    End Function
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jul 2006
    Thank you very much pootle flump. I will try out the method. Appreciate it.

Posting Permissions

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