Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Location
    Kirkland, WA, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing to 2nd Page (Access 97)

    I have a report in Access 97 that occasionally runs to two pages. It has the appearance of a corporate letter so it contains all the elements of standard correspondence, - a header with a corporate logo on the first page, address of the recipient in group header, followed by the detail section displaying different details about the account. Then several footer groups that contain sub-reports. Each of the sub-reports actually are one or two paragraphs that comprise the body of the letter. The content of the letter is determined by user input using a form. After the last footer group is the page footer section that contains carbon copy information, author initials and form reference information. For appearances, I would like this footer information to appear at the very bottom of end of the letter whether it finishes on page one or page two. (For technical reasons, I am unable to use Word for Windows in a mail merge to create this letter.)

    I have inserted code into the header that checks to see if the account number for the underlying source data has changed from page to page. If it has not, then a header for the second page of the letter is inserted into the header section where the logo and corporate return address would normally appear on the first page. This part of the letter performs well.

    My problem comes on the footer of the first and second pages. If the letter is short enough based on user selections, then the header and footer appear on the first page. However, if the letter is longer then it may go to a second page and break in anyone of five different footer groups. When this happens the page footer information ends up on both pages one and two. I want to be able to suppress the footer on page one only if the letter will end up being two pages.

    I have tried using code to capture the WillContinue property and/or HasContinued property of each group section as a format event routine but these properties never seem to change regardless of if the reports breaks to a second page in any given section (they are never true). Any ideas on how I can manipulate the footer in this manner? I am a little confused as to when each of the report event procedures occur as the page moves through each section. I'm wondering if there may be another event I'm not utilizing to suppress the page footer on the first page of a two page report.

    Steve

  2. #2
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing to 2nd Page (Access 97)

    Steve,

    Move everything in the Page Footer to the Report Footer.

    The Report Footer will only print on the last page of the report.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  3. #3
    New Lounger
    Join Date
    Apr 2002
    Location
    Sydney, NSW, Australia
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing to 2nd Page (Access 97)

    I think the report footer appears just below wherever the data finishes - so if the data only just goes over the page, the report footer will start almost at the top of the page. The report footer also print before the page footer

    If you want to keep the data in the page footer which is always the last thing to print, you could try using the page() & pages() values to work out when you are on the last page

    eg in the page footer format event something like ...
    if me.page = me.pages then
    print stuff
    end if

  4. #4
    New Lounger
    Join Date
    Jul 2002
    Location
    Kirkland, WA, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing to 2nd Page (Access 97)

    For all the words I used in my original post, I didn't explain this right. The report in question prints multiple letters each one a little different from the others based on user input. So an entire print job might actually be 100 separate letters or more. Some will only be one page, others will run two pages in length. So I could have any order of 1 or 2 page letters. The report footer will appear on the last page of the report or last page of the print job and wouldn't really work for multiple letters printing in one print job. Guess should have explained this better.

    Steve

  5. #5
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing to 2nd Page (Access 97)

    OK, that's a whole different story.

    Here is a WAG off the top of my head, I would think that you could use grouping and add a group footer.

    It may not be at the bottom of the physical page, but it should be at the end of the group.

    You will have to figure which field to group on, but it shouldn't be that difficult.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Printing to 2nd Page (Access 97)

    Actually, the information required (carbon copy, author's initials, etc.) isn't normally placed at the bottom of a page in a business letter. It comes just a line or two after the signature. Putting it in the group footer would make the report look more like a standard letter than putting it at the bottom of the page.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •