Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    lstReports (Access 97)

    II need to get a list of my reports into a list box and a datasheet for selecting and printing.
    Any help would be greatly appreciated.
    Frank Hoeffer

  2. #2
    Star Lounger
    Join Date
    Feb 2001
    Location
    Wirral, Merseyside, Merseyside, England
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: lstReports (Access 97)

    This query should list all your reports.

    SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") AND (MSysObjects.Type)= -32764 ORDER BY MSysObjects.Name;

  3. #3
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: lstReports (Access 97)

    Careful with using the system tables, though, as MS's official line is that they are unsupported and may change between versions without warning.
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  4. #4
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: lstReports (Access 97) Thanks that did it!!!

    Well that did it much thanks.Caz and Shane Sargent .
    I did not know about the systemobjects table, looks like alot of usefull queries could be made using them. <img src=/S/fanfare.gif border=0 alt=fanfare width=31 height=23>

  5. #5
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: lstReports (Access 97) Thanks that did it!!!

    A little dated perhaps, but I ran across this in a collection of old list of goodies: a list of the reports in a database showing their descriptions so you can keep good naming conventions but show the users a meaningful report name. It's in Access 2000, and you must have a reference set to the DAO Object Library, but it is a handy little beast to have, IMO. The comments are a bit sketchy, but it seems to have originally been in a 1998 issue of what is now Access-VB-SQL Advisor Magazine.
    Attached Files Attached Files
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  6. #6
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: lstReports (Access 97) Thanks that did it!!!

    Thanks Shane-very helpful Frank

  7. #7
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: lstReports (Access 97)

    Thanks but I want to permently not have the Office Bar show up.

Posting Permissions

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