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.
Click to download: Time Zones (zipped)
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.
Please use the contact form below to let me know whether you found this article interesting/useful or if you have any questions/comments.
Also, do let me know if you find any bugs in the application.
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