Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Find out local system time zone?

Posted on 2009-06-30
5
294 Views
Last Modified: 2013-11-27
In Access 2007, how can I find out the time zone being used by the local system, or better yet, the offset from the current local time zone to GMT?
0
Comment
Question by:wsturdev
  • 3
  • 2
5 Comments
 
LVL 16

Expert Comment

by:Chuck Wood
ID: 24746952
I think this will meet your needs:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20877498.html?sfQueryTermInfo=1+time+vba+zone 

If not,  unzip the attached file, change the extension to .bas, and use the functions in this module.
modTimeZones.zip
0
 
LVL 1

Author Comment

by:wsturdev
ID: 24747108
I looked at the link.  I have never seen such a construct before.  Where do I place it?
0
 
LVL 16

Expert Comment

by:Chuck Wood
ID: 24747225
You place it in a separate module.
0
 
LVL 1

Author Comment

by:wsturdev
ID: 24747242
I figured out where to place it.  It gives me the name of my time zone ("Eastern Standard Time").  What I would rather have is "EST" and the offset to GMT (-5).  How can I get that?
regarding the modTimeZones.zip, I unzipped it and changed the extension, but now what do I do with it to get at the functions?
0
 
LVL 16

Accepted Solution

by:
Chuck Wood earned 500 total points
ID: 24747290
To get "EST" and other abbreviations, you would need to create a function that converts the full name to the abbreviation.

To get the offset, you should import the module into your database (Visual Basic window => File => Import File => navigate to the file => select the file => Open. You can then use the LocalOffsetFromGMT function.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question