Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2005
    Posts
    12

    Unanswered: Reports in a Form

    In the past everyone here has been very helpful, so before I begin let me say thank you. I have a form designed in ACCESS, and I want to have a list box to appear on the form which lists all of the reports currently setup for the database. Furthermore, I want the user to be able to choose a report from the list and have it previewed on the screen. Could any of you provide some insight on how to do this. Again, thanks.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Why don't you show them the Report Group in access and show them the way from there????
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Apr 2005
    Posts
    12
    Quote Originally Posted by M Owen
    Why don't you show them the Report Group in access and show them the way from there????
    Unfortunately that won't work for this situation.

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by eidolon74
    Unfortunately that won't work for this situation.
    Why not??? That is basically what you're asking for ... But, that being said ... Try trolling thru the Reports Collection building your list from that. On your listbox doubleclick event, invoke the docmd.openreport with the selected report name from the listbox.
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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