Version 2.3           Updated 11 Nov 2021           Approx 0.7 MB


I made the attached database in response to this thread by MsAxes at AccessForums.net:   How to return current time for specific time zones?

It can used to show the current date & time in different time zones with times being updated each second.

The displayed times allow for daylight saving settings where these are currently in place for particular countries/time zones.



The details for each time zone are saved in table tblTimeZones:



Try changing the date/time in Windows settings. The app will update automatically.

Similarly you can change the default time zone and all dates/times will be updated automatically.

Use an online resource such as World Time Zones By Country to edit the displayed time zones for your own purposes and to update daylight savings data.

The app should be very easy to use. I hope you find it useful.



Download

Click to download:   Time Zones     (zipped)



Video

If you want to understand how it works, please watch the accompanying video on my YouTube channel: Working with time zones or you can click below:



If you liked the app/video, please subscribe to my Isladogs on Access channel on YouTube.



Feedback

Please use the E-Mail button in the contact form below to let me know whether you found this article useful or if you have any questions.

Please also consider making a donation towards the costs of maintaining this website. Thank you.



Colin Riddington           Mendip Data Systems             Last Updated 11 Nov 2021

Return to Example Databases Page

Return to Top