Results 1 to 2 of 2
  1. #1
    SeaTigr is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Nov 2011
    Location
    U.S.A.
    Posts
    38

    One Report Format For Independently Executed Reports From Queries

    Good day all.



    I am developing an inventory database. Presently, I have multiple queries that can be run (system name, serial number, unit type, etc.). Rather than create a report for each query, I'd like to use just one since the same information is reported regardless of query criteria.

    Is there a way to customize the report title/label. Instead of a generic label like "Query Report", for example, set up the label to use the name of the query, i.e. set the label to "System Name Query Report" when the System Name Query is executed and "Serial # Query Report" when the Serial # Query is executed?

  2. #2
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,085
    Yes, as long as the field names are the same. You can set the recordsource, Report Title in the on load event of the report. I've done this previously Using a form for the user to select a specific option in a combo box. Then in the load event of the Report I used a select case statement on what was chosen and set the report title and recordsource to the appropriate query and report name. The only thing you have to watch out for is if the user clicks on the View Report or Print Report (whichever you use to display the report) button before they've acually made a selection in the combo box. I did it by adding a case else and set cancel = true

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 12-01-2011, 01:38 PM
  2. Number format in queries
    By bullwinkle55423 in forum Queries
    Replies: 1
    Last Post: 08-16-2011, 06:55 PM
  3. Access Reports to different file format
    By mar_t in forum Access
    Replies: 3
    Last Post: 03-15-2011, 08:24 PM
  4. Replies: 3
    Last Post: 10-25-2010, 02:07 PM
  5. Replies: 1
    Last Post: 12-16-2009, 04:17 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
  •  
Other Forums: Microsoft Office Forums