CreateObject("Access.Application")

[atzsea]

After declaration of ACCESS application,

Dim AccApp As Object
Set AccApp = CreateObject("Access.Application")
AccApp.Visible = True

After this,

1. I wish to open another prepared DB (Form) in this new Access window.

2. I wish to do other things. What can I do?

I need help.

 

[seaport]

Here are some code from one of my Access database.

    dim appAccess as Access.Application
    Set appAccess = New Access.Application
    appAccess.OpenCurrentDatabase strFilePathAndName
    appAccess.Visible = True
    appAccess.DoCmd.OpenForm strFormName

Hope this can help you.

Seaport