Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2012
    Posts
    27

    Unanswered: Printing subforms in a report without printing a page for each record in subform

    Hello,

    Access 2007
    Windows 7

    I have a question regarding subforms and reports. Here goes.....

    I have a report that I need to pull several records out of a subform. When I set up the report, I have the field for the subform information in it.
    When I print the report, I get a sheet for each and every item in the subform! It prints a single complete form for each one.

    Is there a way to print my form, have my heading for the subform items and them list the subform items together on one sheet?

    I am hoping this is making sense as I type it. I am new to access and don't know the language or what everything is called to make it easier to explain.

    Thank you in advance for any assistance any can provide.

    Thx

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,418
    Provided Answers: 7
    The main report should have just the grouping or header

    the subreport (child)

    should be link to the Main report

    by the
    "Link Master Fields"
    "Link Child Fields"
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Apr 2012
    Posts
    27
    hello and thank you for your reply.

    I am fairly new to access and I am not exactly sure what your answer is referring to. I may be what I am looking for, but I'm not sure. So, I am going to try to explain it a bit more so see if I can clarify.

    I am trying to create a policy sheet. This is how I am hoping it would look when printed.

    1. Heading of policy section
    Policy detail
    a. Policy subsection detail

    I have 2 tables set up. The main table has the policy ID and all the main information regarding to the policy.
    The second table has the policy details. The fields are.... the policy heading number (1.), the heading of the policy, the policy detail, the policy subsection number (a.) and the policy subsection detail

    The reason for this is so the report will line up when printed. I need the text of the policy to NOT wrap under the section number.
    Here is how it looks.

    1. Heading of the policy
    Policy detail
    a. when this section starts to wraps
    it will not line up with the text but with
    the subsection number.

    I need it to look like this....

    1. Heading of the policy
    Policy detail
    a. when this section prints, I
    need it to line up like this.


    I thought that by using a second table, I could get the information to line up by setting up the different fields, BUT when it prints, I only get one subsection per page, and not the list of subsections per heading.

    I need:

    1. Heading of the policy
    Policy detail
    a. this is one subsection
    b. this is another subsection
    c. this is another subsection

    not this:

    1. Heading of the policy
    Policy detail
    a. this is one subsection

    1. Heading of the policy
    Policy detail
    b. this is another subsection

    1. Heading of the policy
    Policy detail
    c. this is another subsection


    I hope this explains what I am trying to get. I may be totally wrong by creating a second table and maybe the memo field (rich text) is all I need, but tab doesn't work, I tried to type it in Word and copy/paste; doesn't work. I couldn't think of another solution.

    I am open to suggestions. Please!!
    Hopefully my explanation isn't too confusing.

    Thanks again for any assistance from anyone!

  4. #4
    Join Date
    Apr 2012
    Posts
    27
    lol of course the formatting didn't work when I posted this so everything looks the same!! Agggghhh!

    I hope I have gotten my question across.
    Thanks!

Tags for this Thread

Posting Permissions

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