Page 2 of 2 FirstFirst 12
Results 16 to 21 of 21
  1. #16
    aellistechsupport is offline Competent Performer
    Windows 7 32bit Access 2003
    Join Date
    Apr 2014
    Posts
    410
    PERFECT!

    Looks like I had it ... "transposed"
    Code:
     DoCmd.OpenReport acOutputTo 




    it should have been
    Code:
    DoCmd.OutputTo acOutputReport


    Thank you!



    By chance, any idea why it's cutting off the Report header and the 1st part of the report?

    The report has 11 subreports and the 1st subreport did not export nor the headers?

  2. #17
    snipe's Avatar
    snipe is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Sep 2013
    Posts
    287
    I have no idea unfortunately. Not without actually seeing it. One of the experts on here will have to help you with that.

  3. #18
    aellistechsupport is offline Competent Performer
    Windows 7 32bit Access 2003
    Join Date
    Apr 2014
    Posts
    410
    for some reason it put it near the bottom?
    this is odd.

    and no header ...

    ok thank you

  4. #19
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    macros are 100 times easier than writing code....you just pick from the box.

  5. #20
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    sorry tried to delete...it wont.

  6. #21
    snipe's Avatar
    snipe is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Sep 2013
    Posts
    287
    Quote Originally Posted by ranman256 View Post
    macros are 100 times easier than writing code....you just pick from the box.
    True, but you are extremely limited as to what you can do.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Export specifications with DoCmd.OutputTo acOutputQuery
    By Mattbro in forum Import/Export Data
    Replies: 2
    Last Post: 03-21-2014, 08:17 AM
  2. DoCmd.GoToRecord
    By Mtyetti2 in forum Access
    Replies: 3
    Last Post: 11-15-2013, 06:59 AM
  3. Replies: 10
    Last Post: 03-12-2013, 01:41 PM
  4. DoCmd****nSQL
    By uncletreetrunk in forum Access
    Replies: 8
    Last Post: 07-17-2012, 10:13 AM
  5. Export to Text File Using DoCmd Access 2007
    By tonere in forum Programming
    Replies: 1
    Last Post: 03-30-2011, 06:14 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