Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Location
    Greensboro, NC
    Posts
    50

    Post Unanswered: Please Help - modified date of the file property

    Please Help


    I want to use the modified date of a file property for a report in Access. How do I import this date so it can be used on the report?

    thanks

  2. #2
    Join Date
    Nov 2002
    Posts
    150

    Re: Please Help - modified date of the file property

    Originally posted by tjacobs
    Please Help


    I want to use the modified date of a file property for a report in Access. How do I import this date so it can be used on the report?

    thanks
    Use the FileDateTime function (pass the the name of the file):

    Dim MyStamp
    ' Assume TESTFILE was last modified on February 12, 1993 at 4:35:47 PM.
    ' Assume English/U.S. locale settings.
    MyStamp = FileDateTime("TESTFILE") ' Returns "2/12/93 4:35:47 PM".

  3. #3
    Join Date
    Oct 2002
    Location
    Greensboro, NC
    Posts
    50

    Re: Please Help - modified date of the file property

    Originally posted by FirstAndGoal4
    Use the FileDateTime function (pass the the name of the file):

    Dim MyStamp
    ' Assume TESTFILE was last modified on February 12, 1993 at 4:35:47 PM.
    ' Assume English/U.S. locale settings.
    MyStamp = FileDateTime("TESTFILE") ' Returns "2/12/93 4:35:47 PM".
    ]


    Thanks!!!

    I will try and let you know the results!
    tjacobs

  4. #4
    Join Date
    Oct 2002
    Location
    Greensboro, NC
    Posts
    50

    Re: Please Help - modified date of the file property

    Originally posted by tjacobs
    ]


    Thanks!!!

    I will try and let you know the results!
    tjacobs
    Thanks A Bunch! IT Works

    in the controlsource under properties of my textbox for the report I put

    controlsource = FileDateTime("y:\foldername\" & ProductID & ".jpg")

    thanks again!
    tjacobs

Posting Permissions

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