Results 1 to 3 of 3
  1. #1
    savwarrior is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2012

    Arrow GMT Time into Access form with Sharepoint List across multiple timezones

    I have a DB with the date/time field in Sharepoint. In my Access form I have the same field which I need to have automatically enter the GMT Time based off of the computer time and location.

    I have been able to create a auto entry for my current location by calculating now()-.0125 and changing the format to get it to show 1930Z (Still having issue with missing the first zero with times between 0000 and 0959) anyway I would like to give the same access form for users in a different time zone and have them be able to update the SP list with the correct GMT Time.

    I could get around this by creating a new form for different timezone users and changing the now() statement but I would prefer to have it correct so any user can load the access form from the web without confusion. There is also the issue of daylight savings time as well since GMT time does not change.



  2. #2
    savwarrior is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2012

    got it

    found my answer!

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    Would you like to share it?
    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 01-05-2012, 11:52 AM
  2. Contact list in Sharepoint 2010
    By atari in forum SharePoint
    Replies: 1
    Last Post: 10-28-2011, 04:12 PM
  3. import/export attachments to SharePoint list
    By Cojack in forum Import/Export Data
    Replies: 0
    Last Post: 07-15-2011, 01:39 AM
  4. sharepoint via vba - run-time error - WHY???
    By is49460 in forum SharePoint
    Replies: 0
    Last Post: 12-01-2010, 10:13 PM
  5. Replies: 1
    Last Post: 09-26-2009, 02:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums