time zone clock

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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...
 
Back
Top