[AccessD] Time zones in Windows

Borge Hansen pcs.accessd at gmail.com
Sun Mar 15 04:17:46 CDT 2020

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.


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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

More information about the AccessD mailing list