Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Oct 2002
    Location
    Kent, Ohio, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Board (Access 2000)

    Need Help....Does anyone know of a good LINK or can tell me how to build a REPORT BOARD....We have a database in Access 2000 and have several reports that we would like the USER to choose from. They would be able to choose from 1 or several reports and PRINT them or just preview them....THANKS IN ADVANCE

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Report Board (Access 2000)

    Just create an unbound form, and add a command button for each report. One of the options that the command button wizard offers is "report operations", with both preview and print report options.
    You would need to set some form properties to make it look OK, (e.g. remove nav buttons and record selectors) then use startup options to make the form come up automatically.
    Regards
    John



  3. #3
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Board (Access 2000)

    Set up a local table with a list of the available reports in. (I avoid directly referencing the 'msys' tables)
    Have a listbox (multi-select if you like) and a button(s) to run the selected report in whichever mode you desire.
    You can then easily add new reports when your user requests them.

    Hope that gives you an idea or two.
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Report Board (Access 2000)

    Here is a sample A97 database that uses a different approach to presenting a list of reports. You need to create a custom property of reports called "DisplayName" and populate it with the name you want to see in the list. You'll find code in on-line help for creating custom properties, but if you need more help, post back.
    Attached Files Attached Files
    Charlotte

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Board (Access 2000)

    Hi Charlotte

    Great piece of code!

    I give up, where do you set Custom "Dispaly Name" property for report displayed names?

    Customer Labels
    Customer Orders Report
    etc

    Second grade version please?

    Thanks for sharing.

    John

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Report Board (Access 2000)

    Since you asked so nicely ...
    Attached Files Attached Files
    Charlotte

  7. #7
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Board (Access 2000)

    Hi Charlotte

    Wow! Thanks for the

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Report Board (Access 2000)

    I'm running SQL Server 2000, which installs MDAC 2.6, but you can also download it from the Microsoft site.
    Charlotte

Posting Permissions

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