[AccessD] MS 365 Upgrade to Family

Wed Mar 1 22:28:13 CST 2023

Ah yes - SendKeys. What a godsend that was when I discovered it. What a
disappointment to find that it was unreliable.  Such a good idea. Forced me
to learn and craft workarounds. So I got along without it.  But what a nice
feature it would be if they fixed it.  Do the later versions of Access
still have SendKeys as a function? Or have they deprecated it out of
existence?

r

On Mon, Feb 27, 2023 at 6:08 PM Juergen Welz <jwelz at hotmail.com> wrote:

>
> https://books.libreoffice.org/en/GS70/GS7013-GettingStartedWithMacros.html#:~:text=The%20most%20powerful%20macros%20in,macro%20scripting%20language%2C%20LibreOffice%20Basic
> .
>
> "Many programmers may not be familiar with LibreOffice Basic, so
> LibreOffice supports macros written in three other languages that may be
> more familiar: BeanShell, JavaScript, and Python."
>
> I'm comfortable with VBA and Windows API calls for most of the MS Office
> suite and have coded in Access, Word, Powerpoint, Excel, Project and even
> Outlook before Microsoft gimped most of the useful Outlook functionality.
> Libre Office certainly offers options.
>
> I wonder whether Microsoft ever fixed the Sendkeys VBA bugs before
> spending time messing with the interface and making it ever more mouse
> dependent.  I expect that the Sendkeys bug still exists after over 25 years
> of being well known and understood.  The help files were once extensive and
> rich with samples and readily accessible back in 97 and 2000 versions.  I
> paid for the 2003 suite and that's the end of me paying Microsoft for
> anything other than Windows.  My current home PC has been running an
> unregistered unactivated version of Windows for 4 years and it won't allow
> me to directly modify user preferences but otherwise runs without
> complaint. My newest laptop came with Windows so I guess they got one pound
> of flesh.
>
> Jurgen Welz
> ________________________________
> From: AccessD <accessd-bounces+jwelz=hotmail.com at databaseadvisors.com> on
> behalf of John Colby <jwcolby at gmail.com>
> Sent: Monday, February 27, 2023 2:13:33 PM
> To: Access Developers discussion and problem solving <
> accessd at databaseadvisors.com>
> Subject: Re: [AccessD] MS 365 Upgrade to Family
>
> I also use LibreOffice.  However it has no vba compatible anything so for
> programming I use MS Access and VBA.
>
> On Sun, Feb 26, 2023 at 4:24 PM Paul Wolstenholme <
> Paul.W at industrialcontrol.co.nz> wrote:
>
> > Arthur,
> >
> > I recommend installing www.portableapps.com<http://www.portableapps.com>
> and installing LibreOffice
> > Portable Still from that.  Updates are automatic (and bundled with
> updates
> > to other useful PortableApps stuff).
> > The LibreOffice Portable Fresh version updates itself more often than I
> > would like.
> > Installing LibreOffice directly from  LibreOffice never was good at
> keeping
> > itself up to date without a manual process to update each PC that I
> > tired of.  I switched from OpenOffice to LibreOffice way back at version
> 4.
> > I did have to tell windows that various file types should be opened using
> > the LibreOffice .exe  located within the hard drive folder structure I
> > assigned PortableApps to use.  That is a one time exercise per PC.
> >
> > This could save you from getting frustrated in a few years time after
> > microsoft convince their customers to use even newer features designed to
> > not work in today's LibreOffice.  Compatibility will be maintained.
> >
> > Paul Wolstenholme
> >
> > On Mon, 27 Feb 2023 at 00:50, John Colby <jwcolby at gmail.com> wrote:
> >
> > > Well hello there.  Long time no see.
> > >
> > > On Sun, Feb 26, 2023 at 1:32 AM Juergen Welz <jwelz at hotmail.com>
> wrote:
> > >
> > > > I've had some experience with Libre Office and there's some funky
> stuff
> > > > but the price is certainly right and its support for most of the MS
> > > office
> > > > suite file formats is really brilliant.  But then, I still own Office
> > > 2003
> > > > and still write some new Access code on Win 11 PCs with it.  I just
> did
> > > > some soccer team management and spectator photo pass retrieval via QR
> > > code
> > > > scan input.  Why get a two ton press when all you need is a single
> > light
> > > > tap with a hammer.  I gave up on buying updated Microsoft
> applications
> > > when
> > > > they introduced the ribbon.
> > > >
> > > > Jurgen Welz
> > > > ________________________________
> > > > From: AccessD <accessd-bounces+jwelz=
> hotmail.com at databaseadvisors.com>
> > > on
> > > > behalf of Arthur Fuller <fuller.artful at gmail.com>
> > > > Sent: Friday, February 24, 2023 7:42:50 PM
> > > > To: Access Developers discussion and problem solving <
> > > > accessd at databaseadvisors.com>
> > > > Subject: Re: [AccessD] MS 365 Upgrade to Family
> > > >
> > > > This aggravation proved just too much, I've decided to abandon the MS
> > > suite
> > > > and begin learning the LibreOffice stuff, for starters.
> > > >
> > > > I will still keep my old 2016 versions, but I think that my
> experience
> > > > today sort of broke the bond I thought we had.
> > > >
> > > > I think that it's time to explore LibreOffice and PostGrSQL in depth.
> > > >
> > > > I realize that I am a krill in their ocean of customers, but given
> that
> > > I'm
> > > > retired, who gives a s**t about what I think? I'm going to embark on
> an
> > > > intensive program studying the LibreOffice stuff, concentrating on
> Base
> > > > (its DBMS), but  looking to see what I can duplicate in the absence
> of
> > > VBA.
> > > > I know that Base offers an equivalent language, so that's Step One.
> > Then
> > > we
> > > > shall see where it goes from there.
> > > >
> > > > On Fri, Feb 24, 2023 at 6:42 PM Kathryn Bassett <kathryn at bassett.net
> >
> > > > wrote:
> > > >
> > > > > And Family comes with 5 more seats, so I've installed on Dave, my
> > > sister,
> > > > > and 2 of Arlene's computers.
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: AccessD <accessd-
> > > > > > bounces+kathryn=bassett.net at databaseadvisors.com> On Behalf Of
> > Susan
> > > > > > Harkins
> > > > > > Sent: Friday, February 24, 2023 11:47 AM
> > > > > > To: 'Access Developers discussion and problem solving'
> > > > > > <accessd at databaseadvisors.com>
> > > > > > Subject: Re: [AccessD] MS 365 Upgrade to Family
> > > > > >
> > > > > > I can only speak from my own experience. My 365 license comes
> with
> > > all
> > > > > the
> > > > > > Power apps and some of them are powerful apps. With the Power
> apps
> > > and
> > > > > > SharePoint (which comes with my 365 license), I have an
> incredible
> > > > number
> > > > > > of easy-to-use tools at my disposal. I'd not go back.
> > > > > >
> > > > > > Susan H.
> > > > > >
> > > > > >
> > > > > > What's the advantage then of 385 over say O2021?
> > > > > >
> > > > >
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> John W. Colby
> Colby Consulting
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>