Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    18

    Unanswered: How to pickup report name, description, date created

    I want to create a table of all my Access reports. How do I pickup the details from the Reports object using VBA code? Thanks for the help.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Actually, a table already exists: MSysObjects. Searching on that should turn up the SQL to list reports. If memory serves, you want a criteria on Type of -32764.
    Paul

  3. #3
    Join Date
    Jun 2004
    Posts
    18
    Thanks, Paul. But I'm missing the report Description. Is this available at all?

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    I've never bothered to use the description, but it doesn't look like it's in that table. I'll poke around and see what I can find.
    Paul

Posting Permissions

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