[AccessD] With / End With or not?

[Bill Benson]

ok

On Fri, Sep 17, 2021 at 8:44 AM Gustav Brock via AccessD <
accessd at databaseadvisors.com> wrote:

> Hi Bill
>
> No. You mix up things. The original question, thus my last comment, was
> about execution speed.
>
> The other topic is about code readability. And that is right: Writing
> highly readably code often takes longer time. Just think about how many key
> entries you would save by not indenting your code.
> Regard it as a long-term investment; it will pay back after some years –
> the day when you review your code.
>
> /gustav
>
> Fra: Bill Benson <bensonforums at gmail.com<mailto:bensonforums at gmail.com>>
> Sendt: 17. september 2021 14:16
> Til: Access Developers discussion and problem solving <
> accessd at databaseadvisors.com<mailto:accessd at databaseadvisors.com>>
> Cc: Gustav Brock <gustav at cactus.dk<mailto:gustav at cactus.dk>>
> Emne: Re: [AccessD] With / End With or not?
>
> You're joking right? It takes FAR less of my OWN microseconds to make use
> of With and use the dots only, than to type or copy paste Target all those
> times!
>
> On Fri, Sep 17, 2021 at 6:03 AM Gustav Brock via AccessD <
> accessd at databaseadvisors.com<mailto:accessd at databaseadvisors.com>> wrote:
> Hi Bill
>
> Perhaps, and we can all believe, but who knows?
> My believe is, that we are discussing microseconds, thus not worth any
> efforts for any normal scenario.
>
> /gustav
>
> Fra: Bill Benson <bensonforums at gmail.com<mailto:bensonforums at gmail.com>>
> Sendt: 17. september 2021 11:47
> Til: Access Developers discussion and problem solving <
> accessd at databaseadvisors.com<mailto:accessd at databaseadvisors.com>>
> Cc: Gustav Brock <gustav at cactus.dk<mailto:gustav at cactus.dk>>
> Emne: Re: [AccessD] With / End With or not?
>
> Gustav, I believe you could AT LEAST have left With Target in there and
> got a performance boost. Small, but real.
>
> On Tue, Sep 14, 2021 at 5:04 AM Gustav Brock via AccessD <
> accessd at databaseadvisors.com<mailto:accessd at databaseadvisors.com><mailto:
> accessd at databaseadvisors.com<mailto:accessd at databaseadvisors.com>>> wrote:
> Hi Arthur
>
> If any gain at all, it will more likely be microseconds.
>
> The use or not of With-End With is rather a matter of preferred coding
> style. Indeed, if you type in an environment like Visual Studio or Visual
> Studio Code (yes, you can code VBA with this) where IntelliSense predicts
> quite well what you intend to type.
>
> The problem with With-End With is, that you easily loose track of the
> object, indeed when nested.
> For fun, I took an old function of mine with what I considered "smart" use
> of With-End With tending the unreadable and rewrote it in "clean" style.
>
> <snip>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>