Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Jerusalem, Israel
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a user who can type dates in manually into a date field, but cannot use the date picker as the year comes out as a wierd number: 09323. This happens on all of the user's Access databases. I use the same databases but do not experience the problem.

    So far we have:
    1) Checked the system clock - the date (including year) is correct
    2) Performed a "Run Microsoft Diagnostics" from inside Access - nothing
    3) Compact and Repair of the user's front end
    4) Shut down/restart of the user's computer

    None of these actions seem to have corrected the error. The user still gets wierd numbers for the year when using the date picker.

    Any ideas how we can fix the date picker?

    Thanks,

    JoeK

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    What version of Office (and Access) are you using? And what are your regional settings on that PC regarding dates?
    Wendell

  3. #3
    2 Star Lounger
    Join Date
    May 2002
    Location
    Jerusalem, Israel
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by WendellB View Post
    What version of Office (and Access) are you using? And what are your regional settings on that PC regarding dates?
    Sorry, forgot the vital information: Office 2007 / Access 2007

    I found that the regional settings for the dates on the user's computer were set differently to mine for the short date - I had 19-Nov-09 and the user had 19/11/09. I changed the user's date format and it worked! The date picker functions normally.

    Thanks for making me aware that the regional date settings could make a difference.

    JoeK

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Glad I was able to help. Access 2007 has a much better date picker than earlier versions, which seemed to be flakey in some situations.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •