How to create Switchboard in Base

Creating and using forms
Post Reply
chamina
Posts: 1
Joined: Tue May 25, 2010 1:24 pm

How to create Switchboard in Base

Post by chamina »

How do I go about creating a Switchboard for base?
OpenOffice 3.2 installed on Windows XP
rudolfo
Volunteer
Posts: 1488
Joined: Wed Mar 19, 2008 11:34 am
Location: Germany

Re: How to create Switchboard in base

Post 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.
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.
evwool
Volunteer
Posts: 401
Joined: Fri Oct 09, 2009 9:40 pm
Location: UK

Re: How to create Switchboard in base

Post 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)
OpenOffice 3.1.1 on Windows XP and on Windows 7 Starter
johnbaser
Posts: 2
Joined: Sun Nov 29, 2020 8:22 pm

Re: How to create Switchboard in Base

Post 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)
.
openoffice 4.1.7
Post Reply