How to create Switchboard in Base
How to create Switchboard in Base
How do I go about creating a Switchboard for base?
OpenOffice 3.2 installed on Windows XP
Re: How to create Switchboard in base
There is a switchboard extension in the Open Office extension repository. This is not the same as what you can do with MS Access, but it's worth a try to see if it fits for your needs.
OpenOffice 3.1.1 (2.4.3 until October 2009) and LibreOffice 3.3.2 on Windows 2000, AOO 3.4.1 on Windows 7
There are several macro languages in OOo, but none of them is called Visual Basic or VB(A)! Please call it OOo Basic, Star Basic or simply Basic.
There are several macro languages in OOo, but none of them is called Visual Basic or VB(A)! Please call it OOo Basic, Star Basic or simply Basic.
Re: How to create Switchboard in base
If you want to make your own, attach code which includes the following to the Mouse Button Released Event of buttons in a form to open a report
And for a form:
Have a hunt in this forum and you'll find examples with more sophistication (eg they check if the report or form is already open before running the code)
Code: Select all
Sub OpenReport(oEvent As Object)
Dim oReport As Object
Dim ReportName As String
ReportName = "RptPeople"
oReport = ThisDatabaseDocument.ReportDocuments.GetByName(ReportName)
oReport.Open
End Sub
Code: Select all
Sub OpenReport(oEvent As Object)
Dim oForm As Object
Dim FormName As String
FormName = FrmPeople"
oForm= ThisDatabaseDocument.FormDocuments.GetByName(FormName)
oForm.Open
End Sub
OpenOffice 3.1.1 on Windows XP and on Windows 7 Starter
Re: How to create Switchboard in Base
I have recently downloaded the switchboard extension
A manual or example would be useful.
(I have used this switchboard successfully before but
not for some time. An example made this possible)
.
A manual or example would be useful.
(I have used this switchboard successfully before but
not for some time. An example made this possible)
.
openoffice 4.1.7