Hello, I was on LO 220.127.116.11 on W7. Yesterday I installed Mysql and last night windows did an update. This morning, LO will not launch. If I delete the user profile I get the splash screen then it shuts down (soffice.exe shows briefly in the task manager). I uninstalled and re-installed to no avail.
I tried LOP version 6.1.6 and it launches fine but a new issue has surfaced with a macro (which I know nothing about). The macro is on a standalone form and launches reports in my database (hdsqldb embedded).
Sub PrintReport(oEvent) Rem Get name of Control sControlName = oEvent.source.Model.Name Rem Check for button pushed If sControlName = "btn6" Then ReportName = "Resto_Report" EndIf If sControlName = "btn7" Then ReportName = "Event_Invoice" EndIf If sControlName = "btn8" Then ReportName = "Birthday_Email" EndIf If sControlName = "btn9" Then ReportName = "Corp_Order_Form" EndIf If sControlName = "btn10" Then ReportName = "Theme_Email" EndIf If sControlName = "btn11" Then ReportName = "Party_Order_Form" EndIf If sControlName = "btn12" Then ReportName = "Party_Order_FormToday" EndIf Rem add more If Statements as needed or even better a CASE statement. oContext = CreateUnoService("com.sun.star.sdb.DatabaseContext") Rem set registered DB name here oFont = oContext.getRegisteredObject("Reservations") '<==================== dbForms = oFont.DatabaseDocument.ReportDocuments oAConnection = oFont.getConnection("","") Dim pProp(1) As New com.sun.star.beans.PropertyValue pProp(0).Name = "ActiveConnection" pProp(0).Value = oAConnection pProp(1).Name = "OpenMode" pProp(1).Value = "open" oForm = dbForms.loadComponentFromURL(ReportName, "_blank", 0, pProp()) End Sub
When running this macro the error shows up in the line
oFont = oContext.getRegisteredObject(“Reservations”)
Who can help? And if anyone can suggest a fix for LO 18.104.22.168 not launching that would help plenty too!
I tried a few more times uninstalling and reinstalling 6.4.2 and it finally launches. My db now opens in Writer instead of Base. I made a backup of my db before doing anything and it opens in Base so I am using that one. The only remaining issue I have appears to be a known bug, standalone forms do not save to the db unless the DB is open.