opening an access apl. from access apl.

[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

 

[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 ...