Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. 11-04-2012, 07:43 PM #16
    Ray67
    Ray67 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    338

    It's working now. I created a new query and added Q_TransactionsDadReport2.
    Reply With Quote Reply With Quote
  2. 11-06-2012, 03:47 PM #17
    Ray67
    Ray67 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    338
    June 7

    Can you help me with post #12. I like your idea about using one form with multiple buttons to run reports. Not sure what would be the VBA for the Ok button.


    Thank You
    Reply With Quote Reply With Quote
  3. 11-06-2012, 04:14 PM #18
    June7's Avatar
    June7
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,633
    Different ways to approach this.

    Can have a listbox of reports. User selects report in listbox. Code in listbox AfterUpdate event opens the selected report. If the text in the listbox is the exact report name, simply:
    DoCmd.OpenReport Me.Listbox

    Or can have individual button for each report.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. How to pass parameters to sub-report on data change in main report
    By s3rcl in forum Reports
    Replies: 1
    Last Post: 03-07-2012, 09:00 AM
  2. Duplicate a business form in an Access Report (add blank records to a report)
    By thekruser in forum Reports
    Replies: 4
    Last Post: 12-13-2010, 05:33 PM
  3. SUMMARY Formula for All Months in Access report Grouped by Month at the End of Report
    By chrisjack001 in forum Access
    Replies: 2
    Last Post: 08-25-2010, 01:42 PM
  4. Access Report using UNION queries - Can I seperate the query results in the report?
    By dso808 in forum Reports
    Replies: 3
    Last Post: 05-21-2010, 03:57 PM
  5. Sub-report backcolor matching alternating row color in main report
    By postman in forum Reports
    Replies: 0
    Last Post: 10-24-2008, 11:20 AM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums