Welcome to SPN

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

Sign Up Now!
  1. Monthly (Recurring) Target: $300 :: Achieved: $95
      Become a Supporter    ::   Make a Contribution   

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page