Results 1 to 6 of 6
  1. #1
    BLD21 is offline Advanced Beginner
    Windows 2K Access 2007
    Join Date
    Apr 2011
    Posts
    55

    Output Report to Excel

    access 2007,
    I've created a macro and I am using the following two action's: OpenReport and then OutputTo. This will output my report as an excel file to a folder. This all works okay. The problem is that within my report I have in the report footer 2 unbound text boxes which I am using for column totals. This appears in my report fine, but when I look at the excel file they are missing. The totals do not come over in the export.

    I am thinking I would need to do this another way?

    Any ideas?

    Bruce D.

  2. #2
    accesskid is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2011
    Posts
    17
    if you are just wanting Headers in the Text boxes they will be not bound to anything so will not show up,

    to make them show up within the text box have this around the text, see example below.

    ="Text header"

  3. #3
    BLD21 is offline Advanced Beginner
    Windows 2K Access 2007
    Join Date
    Apr 2011
    Posts
    55
    I am confused, sorry. This is what I have for the control source of the textbox.

    =Sum([Query1 Totals].[CountOfSORT_DECISION_CODE])

    Now where would I use the = "Text header" so it will carry over to the excel export?

    Thanks.

  4. #4
    accesskid is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2011
    Posts
    17
    this is totally different i was think you were just trying to put a header on the form to show what it is, so ="text header" doesnt mean anything at all thats what the
    equals and double quotes do.

    They make it possible to enter unboundtext.

    Are you trying to create a report?

  5. #5
    BLD21 is offline Advanced Beginner
    Windows 2K Access 2007
    Join Date
    Apr 2011
    Posts
    55
    I have a report created. I want to export it to excel via the "OutputTo" action in my macro. This works just fine but it does not bring over my totals which are the unbound text boxes that calcuated the sums. Is there a way to make sure that these totals get exported over to excel as well.

    Thanks!

  6. #6
    accesskid is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2011
    Posts
    17
    surely if they are calculating the sums they are bound to some fields you have? do you mean they are used as headers if so just put ="whatever your header is" between the double quotes

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

Similar Threads

  1. Output tables to an excel file on a network drive
    By GraemeG in forum Import/Export Data
    Replies: 1
    Last Post: 04-01-2011, 03:06 PM
  2. Formatted Excel Output
    By jerryrs in forum Import/Export Data
    Replies: 6
    Last Post: 02-26-2011, 11:58 PM
  3. URGENT HELP: output to excel
    By jerryrs in forum Import/Export Data
    Replies: 1
    Last Post: 12-22-2010, 12:18 PM
  4. Replies: 0
    Last Post: 03-01-2010, 02:53 AM
  5. Exporting a Report to Excel
    By bullwinkle55423 in forum Reports
    Replies: 0
    Last Post: 12-11-2007, 10:27 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