Page 1 of 1
How to create Switchboard in Base
Posted: Mon May 31, 2010 11:22 am
by chamina
How do I go about creating a Switchboard for base?
Re: How to create Switchboard in base
Posted: Mon May 31, 2010 4:23 pm
by rudolfo
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.
Re: How to create Switchboard in base
Posted: Mon May 31, 2010 6:36 pm
by evwool
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
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
And for a form:
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
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)
Re: How to create Switchboard in Base
Posted: Mon Nov 30, 2020 12:16 am
by johnbaser
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)
.