Results 1 to 5 of 5
  1. #1
    cuddles is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    98

    modify my outputto command button

    I am trying to create my command button to allow me to say use this background img on page 1 and use this background image on the rest of the pages when saving the file.

    Code:
    private sub command36_click()
    docmd.outputto acoutputreport, "Report1", acformatpdf, myreportoutput, , , , acexportqualityprint
    Is there a way to do that in this command? I have the background picture set to a page already when the form is viewed, however when it prints or saves to pdf it puts the background on all pages following and it does not line up like the first page does. It jumbles the data on top of the words and just does not look right. Now, I could do something else like tell the data on all pages following the first to begin printing on X portion of the page so it does not go on top of the writing that apprears on the background image at the top. The image was taken from a ppt that is now a jpg.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    No, OutputTo cannot modify the report structure.

    However, I don't quite understand what you are doing.

    You say 'when the form is viewed' - did you mean report?
    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.

  3. #3
    cuddles is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    98
    Yes, sorry. I have a report and there is a background picture on the report and when it prints, the first page is perfect but the pages that follow are not lined up right per the background. The picture was a ppt that was used and then stretched out and fits perfect on the page and looks very professional, however because the rows that follow start at the top of the page, they are displayed over the logo at the top of this picture. Here is an example of what I mean:

    Click image for larger version. 

Name:	1.jpg 
Views:	6 
Size:	137.2 KB 
ID:	16453

    Click image for larger version. 

Name:	2.jpg 
Views:	6 
Size:	155.3 KB 
ID:	16454

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Maybe activate the Page header section of the report and size it big enough to push the records down below the image text.

    Could rebuild the image so that the text is not included then put the text into Page header section of the report.
    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.

  5. #5
    cuddles is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    98
    Perfect. Thanks. I just used the background as the picture and then in report header put what I want and the header is on the first page aligned perfect and the all pages following just have background and look great. Thanks so much.

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

Similar Threads

  1. VBA for Command Button
    By noaccessguru in forum Forms
    Replies: 1
    Last Post: 08-25-2013, 11:17 PM
  2. Replies: 3
    Last Post: 08-04-2013, 07:11 AM
  3. modify button
    By imintrouble in forum Forms
    Replies: 5
    Last Post: 10-13-2011, 01:52 PM
  4. command button
    By berni3883 in forum Forms
    Replies: 17
    Last Post: 04-22-2011, 12:04 AM
  5. Replies: 1
    Last Post: 07-27-2010, 02:27 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