Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Jerusalem, Israel
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have about 200 queries (and reports and macros...) in an Access 2000 DB. I would like to be able to display or print a list of their names. How would I do that?

    Thanks!

    JoeK

  2. #2
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post
    You can use the built in database documentor in database utilities

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    [quote name='joek' post='771550' date='21-Apr-2009 11:32']I have about 200 queries (and reports and macros...) in an Access 2000 DB. I would like to be able to display or print a list of their names. How would I do that?[/quote]
    You can also use this query:

    Select MsysObjects.Name FROM MsysObjects WHERE MsysObjects.Type=5 AND msysobjects.Name Not Like "~*" ORDER BY msysobjects.Name;
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    2 Star Lounger
    Join Date
    May 2002
    Location
    Jerusalem, Israel
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='MarkLiquorman' post='771567' date='21-Apr-2009 19:07']You can also use this query:

    Select MsysObjects.Name FROM MsysObjects WHERE MsysObjects.Type=5 AND msysobjects.Name Not Like "~*" ORDER BY msysobjects.Name;[/quote]

    Thanks! I didn't know about the Documenter (which I tried), but I think that for my purposes, this query does the trick.
    See, learn something new every day.

    JoeK

  5. #5
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    [quote name='joek' post='771720' date='22-Apr-2009 09:15']Thanks! I didn't know about the Documenter (which I tried), but I think that for my purposes, this query does the trick.
    See, learn something new every day.[/quote]
    Yeah, the built-in Documenter tends to give you more information than you need, with no way to limit it. That's why I created my own Table Documenter which is part of my Liquorman Utilities. I might consider adding a Query Documenter to it!
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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