Results 1 to 4 of 4
  1. #1
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Printing Page Header on Main Report (Access 2000 - 2003)

    Sub Reports have NO Page Header.
    I have a Sub Report where the Column Headings are in the Report Header section.
    BUT if the sub report goes over a page they do not appear on the next page.
    I could get round this by putting headings on the Main Report,
    BUT is there any way to determine when the sub report goes to a second page?
    If I knew this I could use it to determine whether to make the Main reports Page Header Visible Or NOT.
    Seems a bit of an omission by MS but I may be missing something simple.
    Andrew

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Printing Page Header on Main Report (Access 2000 - 2003)


  3. #3
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Printing Page Header on Main Report (Access 20

    It looks like it is going in the right direction BUT for the life of me I cannot get it to work.
    I used VBA NOT Macros but...)

    So here is what I would like to happen.

    In the Main Report Page Header there are some Headings that Line up with the Sub Reports headings.
    The Sub Report Has it's own headings in the Sub Reports Header.
    The Sub Report resides as part of the detail Band.
    At the end of the detail section there is a page break (after)

    ALL OK SO FAR.

    When the Report prints I would like the following to happen.

    When the Subreport prints its first page then it should use the report header in the SubReport,
    and the Main Reports Page Header should not print (or be hidden).

    If the sub report goes to a second page then the Page Header of the Main Report should print.
    This should print on all subsequent pages until the SubReport starts to print again, when it needs to use the Sub Reports Header BUT Not the Main Reports Page Header).

    I almost got it to work BUT it failed to print the headings on the second page of the subreport although it was OK on the 3rd oddly.

    Hope that's not too difficult to follow.

    I am going off to get my thinking cap.

    If anyone gets this to work I'd love to know the solution.
    Andrew

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Printing Page Header on Main Report (Access 20

    It *is* rather tricky to get it right. Could you post a stripped down copy of your database? See <post#=401925>post 401925</post#> for instructions.

Posting Permissions

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