Open external form in another database

[Alvein17]

Dear All,

heloo,

how to open external database? i was created button (Input DB) in my access application to open file Kategori.mdb but it's not works.
here i capture picture, please see the picture below:

From this:

to this:

so, when i click input DB it will open kateogri.mdb

here i share my query:
Dim accapp As Access.Application

Set accapp = New Access.Application

accapp.OpenCurrentDatabase ("D:\Access Application\Kanrigenka Application\AOCR App\Kategori.mdb")
accapp.Visible = True
End Sub



can you suggest to me how to fix my query?

thank you All.

 

[June7]

That is not a query, it is VBA procedure.

What does "not work" mean - error message, wrong result, nothing happens?

Review https://www.access-programmers.co.uk/forums/threads/how-to-open-another-database-using-vba.129779/

 

[arnelgp]

Option Explicit
Dim accapp As Access.Application

Private Sub button_Click()
    If Not (accapp Is Nothing) Then
        'accapp.Quit
        Set accapp = Nothing
    End If
    Set accapp = New Application
    accapp.Visible = True
    accapp.OpenCurrentDatabase ("D:\Access Application\Kanrigenka Application\AOCR App\Kategori.mdb")
    accapp.DoCmd.OpenForm "theFormYouNeedToOpen"
End Sub

 

[Saphirah]

ArnelGP's solution is probably the best. Another thing you could do is the following:

Create a macro in your second database. Then call the following procedure in your first database:

Sub OpenMacroInOtherDatabase(macroName As String, Optional parameters As String)
    Call Shell("msaccess.exe YourFilePath/YourFileName.accdb /x " & macroName & IIf(IsStringEmpty(parameters), "", "/cmd " & parameters))
End Sub

This will open a new access instance and execute the macro. With this you can open forms, call vba and much more.

 

[MajP]

Post in thread 'Open specific form in external DB' https://www.access-programmers.co.u...cific-form-in-external-db.302599/post-1600713
You can do this very easily by adding a reference to the second db. No need to open the external db and it appears as if it is part of the main db.