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.
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)