[AccessD] Time zones in Windows

[Gustav Brock]

Hi Borge

Most of the listers have retired or moved to other environments, I believe.

No, I don't know of some ready-built method for version control. I just zip the full file.

Quite different, but you may be interested in http://rubberduckvba.com/

/gustav


________________________________
Fra: AccessD <accessd-bounces at databaseadvisors.com> på vegne af Borge Hansen <pcs.accessd at gmail.com>
Sendt: 15. marts 2020 10:17
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: Re: [AccessD] Time zones in Windows

Hi Gustav,
Many thanks for sharing on the AccessD list ...
Very quiet here these days, wonder why...

If you have any links to information / tips / ideas for how to use git /
github to version control an Access application, I’d really appreciate it.

And to everyone, best wishes that you all stay well, safe and happy during
this pandemic.

/Borge

On Tue, 10 Mar 2020 at 11:25 pm, Gustav Brock via AccessD <
accessd at databaseadvisors.com> wrote:

> Hi all
>
> My latest article is two-fold:
>
> Time Zones, Windows, and VBA - Part 1<
> https://www.experts-exchange.com/articles/33988/Time-Zones-Windows-and-VBA-Part-1.html
> >
> Obtaining and using time zones in Windows is not simple. It involves API
> calls and reading the Registry. Some information is localised, and some is
> not. Here you will find a complete set of functions that wraps the
> difficult steps, eases common tasks, and helps when designing user
> interfaces.
>
> Time Zones, Windows, and Microsoft Office - Part 2<
> https://www.experts-exchange.com/articles/33997/Time-Zones-Windows-and-Microsoft-Office-Part-2.html
> >
> Listing and selecting time zones in Microsoft Access and Excel is not
> straight forward. In the previous article was shown how to retrieve the
> time zones of Windows. Here will be demonstrated how to create tables to
> store these and how to display and select a time zone in Microsoft Access
> and Excel.
>
> I was so tired of all the small bits and pieces collected through the
> years that didn't play well together, that I decided to write a complete
> set of functions for the purpose.
> It also includes yet an example of a CallBack function in Access.
>
> Both an Access and an Excel demo are attached the articles.
>
> Full and current code and demos can be found at any time on GitHub:
> VBA.Timezone-Windows<https://github.com/GustavBrock/VBA.Timezone-Windows>
>
> /gustav