Re: Nobody Ever Lay On Their Deathbed Thinking ...

On 1/8/2025 4:39 PM, Lawrence D'Oliveiro wrote:

On Sat, 4 Jan 2025 10:47:47 -0500, DFS wrote:
 

Plus it's slow (at least on Windows).

 Maybe the fault lies with Windows?

No doubt it's a conspiracy by Microsoft.

  Plus LO Basic is pure crap.

 s/LO Basic/Basic/

VBA makes absolute mincement out of LO Basic.  VBA is built for and great for manipulating the Office environment and managing data.

Plus LO Base is a sad joke.

 It offers much more advanced DBMS functionality than Microsoft Access can
match.

Prove this claim in detail, with screenshots and code as needed.

Plus the form and report designers are bogus.

 What can Office do that they can’t?

TONS^2, as I've explained here several times.
You and Joel should educate yourselves.  LO is free, and MS Office Pro (versions 2003-2024) can be bought very cheaply from eBay or Gamers-Outlet or other sites, $10 to $50.
I'll give you a couple teasers (Office 2003):
*  the Access form designer offers NINE types of autoforms/starters to
    quickly give you a skeleton layout you can then customize
    https://imgur.com/5zJKuWM
*  the Access report designer lets you easily add standalone code or
    existing macros to every section of the report (header, footer,
    group/s, detail) or to the report object itself (which code fires
    during report events activate/deactivate, open/close, error, Page,
    NoData).  I couldn't find a way to add LO Basic code to an LO report
    at all.
The LO Base reporting functionality is buggy and weird and limited... just FUBAR:
* create a report on a table, save the report, dbl-click to open it and
   it shows the data as expected.  It also says 'This document is open in
   read-only mode.' and there's an 'Edit Document' button.  Click that
   button and it changes into a weird spreadsheet-like edit mode where
   you can make changes to the labels and the data (insert rows, delete
   rows, edit data), but those label changes aren't saved, and data
   edits aren't propagated to the underlying table.  I don't get it.
* LO Base report objects have 10 editable properties and settings.  MS
   Access report objects have 47.
* LO Base labels have 16 editable properties; Access report
   labels have 32.
* LO Base data fields have 20 editable properties; Access report
   data fields have 39.
   https://imgur.com/a/6yaK2q3
* the LO Base report design ruler doesn't toggle on and off correctly.
   If it's off it will turn on, but if it's on it won't turn off - until
   you save and close/reopen the report in design mode.  Somebody should
   file a bug report so it will get fixed this decade.
There are many, many oddball bugs and weird behaviors in LO form and report designers.
I once inherited a gnarly Access report and subreport combo, which the original developer claimed couldn't be combined into one report object. A few hours later I had it done, and he was "quite impressed".
MS Office is my man, and LO is my bitch.
Let the excuse-making begin.  Bring Feeb in: that fraud loves to dismiss LO's shortcomings vs Access.

Plus LO has no email component.

 Remember, Microsoft dates from the time when email was very much a vendor-
proprietary function. The idea of being able to send messages between
machines on different LANs was still new and exotic, or just plain fantasy
to some.

huh?  LibreOffice dates from before MS Office, to 1985 when it was proprietary StarOffice, then FOSS OpenOffice in 2000, then FOSS LibreOffice in 2011.
Face facts: MS is smarter than FOSS and works harder than FOSS.