Results 1 to 2 of 2

Export Report with Page Headers to Excel

  1. #1
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    253

    Export Report with Page Headers to Excel

    When I try to export a report that has text boxes in the page headers (from Print Preview screen), the name of the text boxes appear as column headings, but the data does not. What do I need to do? Thanks, Eddie

  2. #2
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    31,267
    I don't think can do anything. The export wizard appears to export data only from Detail and Group sections.
    To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

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

Similar Threads

  1. Export First Page of Report for Each Unique Header
    By ertweety in forum Programming
    Replies: 3
    Last Post: 06-05-2012, 05:23 PM
  2. Control Page Headers with VBA?
    By FL_Boy in forum Reports
    Replies: 3
    Last Post: 12-22-2011, 01:49 PM
  3. Sub report page headers
    By rahayes in forum Reports
    Replies: 3
    Last Post: 11-11-2011, 02:21 AM
  4. Page Break in Report Headers
    By JonathanT in forum Reports
    Replies: 8
    Last Post: 06-30-2011, 09:37 PM
  5. Too many page headers for one report?
    By Swilliams987 in forum Reports
    Replies: 0
    Last Post: 02-14-2011, 09:36 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
  •  
Tech Forums: Microsoft Office Forums