Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

opening an access apl. from access apl.

Discussion in 'Information Technology' started by avner, Jul 28, 2006.

  1. avner

    avner
    Expand Collapse
    Guest

    i have an access application and i need to add ability to open another access
    application (by Botton).

    i tried Run App. it didn't work

    any idea

    thanks

    avner
     
  2. Loading...


  3. datAdrenaline

    datAdrenaline
    Expand Collapse
    Guest

    Do you want to have the new Access application be a "child" of the current
    app. What this means is that the Second instance of MSAcces would close when
    the app reference goes "out of scope" in the first application.

    To create an access app that is as described above:

    Public Sub foo()
    Dim appAccess As Access.Application
    Set appAccess = New Access.Application
    With appAccess
    .OpenCurrentDatabase ....
    >>>

    Put some more code here to do what you want
    <<<<
    .CloseCurrentDatabase ...
    End With
    appAccess.Close
    Set appAccess = Nothing
    End Sub

    .... Or ...

    If you what to spawn an new independant (sortof) MSAccess application ...
    check out the following:

    Shell()
    Application.Followhyperlink

    Hope the helps ...


    --
    Regards,
    Brent Spaulding
    datAdrenaline


    "avner" wrote:

    > i have an access application and i need to add ability to open another access
    > application (by Botton).
    >
    > i tried Run App. it didn't work
    >
    > any idea
    >
    > thanks
    >
    > avner
     

Share This Page