Example Apps for Businesses, Schools & Developers

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