I have made a standalone “switchboard” with buttons to launch the individual forms in DB (hsqldb 6.4.2) and they work great.
1- I have a few buttons with macros assigned to them to launch the various reports I have. When I launch each report manually within the LO db they work fine. When I use the switchboard form within LO the User Parameter dialog box I put in my queries appears, I enter the data (a date range as an example) then it hangs. When I use the button for my reports on the standalone form I get an error.
2- LO is recommending I migrate to Firebird. If I accept, will I have to redo anything in my forms or queries?
Here is the macro I have
REM ***** BASIC *****
Sub OpenBDayEmail '(oEvent As Object)'
RptName = "Birthday_Email"
ThisDatabaseDocument.ReportDocuments.getByName(RptName).open
End Sub
Sub OpenCorpOrder '(oEvent As Object)'
RptName = "Corp_Order_Form"
ThisDatabaseDocument.ReportDocuments.getByName(RptName).open
End Sub
Sub OpenEvent_Invoice '(oEvent As Object)'
RptName = "Event_Invoice"
ThisDatabaseDocument.ReportDocuments.getByName(RptName).open
End Sub
Sub OpenParty_Order_Form '(oEvent As Object)'
RptName = "Party_Order_Form"
ThisDatabaseDocument.ReportDocuments.getByName(RptName).open
End Sub
Sub OpenResto_Report '(oEvent As Object)'
RptName = "Resto_Report"
ThisDatabaseDocument.ReportDocuments.getByName(RptName).open
End Sub
Sub OpenTheme_Email '(oEvent As Object)'
RptName = "Theme_Email"
ThisDatabaseDocument.ReportDocuments.getByName(RptName).open
End Sub
Thanks to anyone who can pitch in