Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    21

    Unanswered: Query properties question??

    Is there a property or a method to get the date a query or table was last modified? I want to have a msgbox that says, "The query was last refreshed on *DATE OF LAST MODIFICATION HERE*. Would you like to refresh now?"
    Any help would be appreciated.

  2. #2
    Join Date
    Jul 2004
    Posts
    125
    If you right click on the Query and select Properties, this will tell you the creation and last modification date. You can read these values in code by checking the Query properties. I hope this is what you were looking for.

  3. #3
    Join Date
    Jun 2004
    Posts
    21
    Quote Originally Posted by ineuw
    If you right click on the Query and select Properties, this will tell you the creation and last modification date. You can read these values in code by checking the Query properties. I hope this is what you were looking for.

    If I was writing the code in VBA what property or method would be used to retrieve this? 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
  •