Results 1 to 2 of 2
  1. #1
    markjkubicki's Avatar
    markjkubicki is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jul 2010
    Location
    Fire Island Pines, NY
    Posts
    496

    significantly varying footer and header... same detail

    I have a report whose detail section is fairly complicated in both layout and code, but is always the same format; however, dependign on who the report is issued to... the format of the header and/or footer can vary significantly. At present, there are only a few variations (3); however, I need to presume that in the future, there will inevitably be more...

    Currently, I have one report with many text boxes, labels, etc in the footer, and a choice made by the user, determies which are displayed, where they are located, and to some degree, their content and the format of their content (all set by code...) confusing, difficult to manage, messy...

    is there a better approach?



    lost in the wilderness, but with many thanks to offer in advance,
    Mark

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Alternative to all that messy code is separate report for each recipient. Be thankful for copy/paste. Then user selection will determine which report to open. Only issue is if the Detail section design changes have to change multiple reports, unless the detail section could be a subreport that would be common to all main report versions.
    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.

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

Similar Threads

  1. Replies: 3
    Last Post: 11-17-2015, 05:49 PM
  2. space between Detail and Footer
    By ConfusedMike in forum Reports
    Replies: 5
    Last Post: 11-17-2015, 05:46 PM
  3. Replies: 9
    Last Post: 04-21-2013, 05:37 PM
  4. Header and Footer
    By tcheck in forum Access
    Replies: 1
    Last Post: 11-08-2012, 02:23 PM
  5. header and footer
    By slimjen in forum Forms
    Replies: 2
    Last Post: 10-03-2011, 08:10 PM

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