Opening and hiding base documents

[Oldgoat]

The 3.x documentation suggests this for opeining a database document but it doesn't seem to work, yielding a message about a "wrapper."

Sub Initialize '=== Triggered by .odb OPEN event
ThisDatabaseDocument.FormDocuments.getByName( "TRANSACTIONS" ).open
End Sub

This, cobbled together from various forum posts, works (opens the desired form) but it doesn't load the form in the same frame, and leaves the .odb document visible to users.

Function OpenFormViaConnection(aFormName as String) as variant

dim sqlconnection as variant
dim oFormContainer as variant
dim oDoc as variant
dim oFrame as variant
dim aProp(1) As New com.sun.star.beans.PropertyValue

'On Error Goto Handle_Error
sqlconnection = thisDatabaseDocument.DataSource.getConnection("","")
aProp(0).Name = "ActiveConnection"
aProp(0).Value = sqlconnection
oFormContainer = thisDatabaseDocument.FormDocuments
If oFormContainer.HasByName(aFormname) Then
oDoc = oFormContainer.loadComponentFromURL(aFormname,"_Self",2,aProp())
oDoc.CurrentController.Frame.ComponentWindow.setFocus()
oFrame = oDoc.CurrentController.Frame
'Toolbars_Hide(oFrame)
End If
OpenFormViaConnection = oDoc

Handle_Error:
If err <> 0 Then
Msgbox "Error " & Err & " occurred loading Form [" & aFormname & "]"
OpenFormViaConnection = NULL
Exit Function
End If
End Function

I'm doing an app that starts with and depends on a switchboard function. Can anyone help with the following?

1. After opening the initial form, I can easily make the top-level .odb document invisible: 'ThisDatabaseDocument.CurrentController.ApplicationMainWindow.SetVisible(False).
But that leaves the .odb running and inaccessible, of course. If a user closes a child form, the whole app closes, but leaves the top document running. You have to execute it again and then close it. How can I hide the top .odb form yet have it go away when the app closes?

2. Notice in the code above the use of "... , _Self, 2, Aprop() " in the LoadComponentFromURL line. This does NOT load the form into the top .odb frame, but creates a new frame. Further, after opening the form, opening another one works, but now there are two frames and two windows for user to manage. That is,

oDoc = oFormContainer.loadComponentFromURL(aFormname,"_Self",2,aProp())
wait(2000)
oDoc = oFormContainer.loadComponentFromURL("ACCOUNTS,)","_Self",2,aProp())

Results in THREE documents open and visible: the top .odb and both forms.

How can I get a form to load in the "current" frame? I've done that extensively with text documents with embedded forms but database documents seem to be a whole different animal.

Thanks for any help

[RPG]

Hello

I cannot give an answer on your question how you ask it.

But maybe this can help you
You can make only a writer document doing the same things as you want.
That means a forms outside a database.

Romke

[Oldgoat]

Yes, thanks. I've done that extensively for the past several years, but the 3.x abiilty to handle macros within the database makes Base a better product with a brighter future and I'd like to use the new functionality. Unfortunately I can't make it work.