Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2006
    Posts
    11

    Unanswered: Acc97 on Vista - Date Format Problem?

    Hi,
    I loaded a Access 97 onto a Vista Home edition pc.
    Everything seems to work except for any reference to Date().

    I had the Date() in a default field on a table and I had a "=Format(Date(),'ShortDate')" on reports and screens.

    How come the Date() doesn't work on Vista??


  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    It does work. On my machines at least

    Check out your references... which is the only thing I can think of that would disable Date() references... among other things.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    it is probably not Vista's fault.
    try using Now() in place of Date() - since both are in the same library it is strange that Now() often works when Date() doesn't.
    try running the following on working & not machines:
    Code:
    Private Sub SomeButton_Click()
        Dim aref As Reference
        For Each aref In Application.References
            Debug.Print aref.Name & " " & aref.Major & "." & aref.Minor, "Broken: " & aref.IsBroken, aref.Guid
            Debug.Print , aref.FullPath
        Next
    End Sub
    maybe there is a VBA version issue.

    izy
    currently using SS 2008R2

  4. #4
    Join Date
    Nov 2006
    Posts
    11
    Okay thanks to both of you.
    I am not in front of the Vista pc yet to check those yet.

    I will get back to you.

    Thanks


Posting Permissions

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