time zone clock

K

Kevin76

I am building a Access employee db and want people to be able to see a person
local time when they pull a person up on a form. This is a global group. I
am using the following source http://www.mvps.org/access/forms/frm0051.htm to
create a form that a user chooses the time zone they reside. So far I have
been able to create the drop down that stores the persons time zone in the
employee table record. Now I want to be able to pull up that time zone and
show their local time on a form when there record is chosen. Is this
possible?
 
A

Arvin Meyer [MVP]

Yes,

In addition to Pedro Gil's method, as shown in the article on the Access
Web, you can simply relate everyone's time zone to GMT . My time in the
Eastern US is -05:00 which means that if someone on the West Coast of the US
(-08:00) is at 6:15 PM, I'm 3 hours later, or 9:15 PM:

8 -5=3

and someone in the UK is 5 hours later than that (or tomorrow at 2:00 AM)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
K

Kevin76

What is GMT and how would you do this?

Arvin Meyer said:
Yes,

In addition to Pedro Gil's method, as shown in the article on the Access
Web, you can simply relate everyone's time zone to GMT . My time in the
Eastern US is -05:00 which means that if someone on the West Coast of the US
(-08:00) is at 6:15 PM, I'm 3 hours later, or 9:15 PM:

8 -5=3

and someone in the UK is 5 hours later than that (or tomorrow at 2:00 AM)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
Click to expand...
 
Top