Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Help! How can I print all tabs of a form?

Discussion in 'Information Technology' started by NB, Jul 28, 2006.

  1. NB

    NB
    Expand Collapse
    Guest

    I have a 3 page form. Because Access only allows 22" in length, I put each
    page on a tab. I need to print tab1, tab2, tab3 all at once, before going to
    the next record. How can I print multi-tabbed forms?

    If that can't be done, what is the correct way to design a long (3-5 page)
    form?

    NB
     
  2. Loading...


  3. SusanV

    SusanV
    Expand Collapse
    Guest

    You should print reports, not forms. Reports can go hundreds of pages, and
    can be formatted to look much nicer than forms.
    --
    hth,
    SusanV

    "NB" <NB@discussions.microsoft.com> wrote in message
    news:C0FF147A-48F6-45F3-92C3-7F318E65B092@microsoft.com...
    >I have a 3 page form. Because Access only allows 22" in length, I put each
    > page on a tab. I need to print tab1, tab2, tab3 all at once, before going
    > to
    > the next record. How can I print multi-tabbed forms?
    >
    > If that can't be done, what is the correct way to design a long (3-5 page)
    > form?
    >
    > NB
     
  4. Rick B

    Rick B
    Expand Collapse
    Guest

    You don't PRINT forms. You print reports.

    Build a report that is formatted to properly fit on the page the way you'd
    like.

    Forms are designed for viewing, adding, and changing data. Reports are
    designed to print data.

    --
    Rick B



    "NB" <NB@discussions.microsoft.com> wrote in message
    news:C0FF147A-48F6-45F3-92C3-7F318E65B092@microsoft.com...
    >I have a 3 page form. Because Access only allows 22" in length, I put each
    > page on a tab. I need to print tab1, tab2, tab3 all at once, before going
    > to
    > the next record. How can I print multi-tabbed forms?
    >
    > If that can't be done, what is the correct way to design a long (3-5 page)
    > form?
    >
    > NB
     
  5. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Fri, 9 Jun 2006 09:14:01 -0700, NB <NB@discussions.microsoft.com>
    wrote:

    >If that can't be done, what is the correct way to design a long (3-5 page)
    >form?


    If you want to print the data, use a Report. Forms are designed for
    onscreen viewing and editing (tab pages let you share screen space);
    they're not optimized for printing. Reports are.

    John W. Vinson[MVP]
     
  6. NB

    NB
    Expand Collapse
    Guest

    Susan,
    I have the same problem in reports - it can print hundreds of pages of
    records, but the layout will only allow 22" in the detail section. My fields
    take up 3 pages, because I have to give enough space for the reviewers to
    hand-write comments in each section.

    The purpose of this form (or report) is for Site Reviewers to take them to
    review a site against criteria. The top portion must pre-populate with the
    site data (name, address, etc.). The rest are fields with blanks and comment
    sections for the reviewers to fill out (by hand) as they walk the site.

    I can create the form for inputting the hand-written data into the dbase -
    that isn't a problem, but the "pre-populated" form to give to the reviewers
    is 3 pages long. Your thoughts?

    "SusanV" wrote:

    > You should print reports, not forms. Reports can go hundreds of pages, and
    > can be formatted to look much nicer than forms.
    > --
    > hth,
    > SusanV
    >
    > "NB" <NB@discussions.microsoft.com> wrote in message
    > news:C0FF147A-48F6-45F3-92C3-7F318E65B092@microsoft.com...
    > >I have a 3 page form. Because Access only allows 22" in length, I put each
    > > page on a tab. I need to print tab1, tab2, tab3 all at once, before going
    > > to
    > > the next record. How can I print multi-tabbed forms?
    > >
    > > If that can't be done, what is the correct way to design a long (3-5 page)
    > > form?
    > >
    > > NB

    >
    >
    >
     
  7. SusanV

    SusanV
    Expand Collapse
    Guest

    Ah, now I see your problem - I had a similar one for field techs.
    The solution I used was to create a Word Merge Document to print - Word will
    let you do whatever it is you need to do.

    Open the table or Query the form is based on, go to tools>Office Links>
    Merge it with MS Word. Select the fields from the left side dropdown,
    inserting whatever text you want for the labels, add blank lines (or
    underlined spaces if you like) for the fill-in sections, page breaks,
    company logo, images, whatever. Save it someplace. Then click on Merge, and
    select new document, and you should be good to go!


    --
    hth,
    SusanV



    "NB" <NB@discussions.microsoft.com> wrote in message
    news:81D37BD1-D834-44BB-87A2-F062243F2169@microsoft.com...
    > Susan,
    > I have the same problem in reports - it can print hundreds of pages of
    > records, but the layout will only allow 22" in the detail section. My
    > fields
    > take up 3 pages, because I have to give enough space for the reviewers to
    > hand-write comments in each section.
    >
    > The purpose of this form (or report) is for Site Reviewers to take them to
    > review a site against criteria. The top portion must pre-populate with the
    > site data (name, address, etc.). The rest are fields with blanks and
    > comment
    > sections for the reviewers to fill out (by hand) as they walk the site.
    >
    > I can create the form for inputting the hand-written data into the
    > base -
    > that isn't a problem, but the "pre-populated" form to give to the
    > reviewers
    > is 3 pages long. Your thoughts?
    >
    > "SusanV" wrote:
    >
    >> You should print reports, not forms. Reports can go hundreds of pages,
    >> and
    >> can be formatted to look much nicer than forms.
    >> --
    >> hth,
    >> SusanV
    >>
    >> "NB" <NB@discussions.microsoft.com> wrote in message
    >> news:C0FF147A-48F6-45F3-92C3-7F318E65B092@microsoft.com...
    >> >I have a 3 page form. Because Access only allows 22" in length, I put
    >> >each
    >> > page on a tab. I need to print tab1, tab2, tab3 all at once, before
    >> > going
    >> > to
    >> > the next record. How can I print multi-tabbed forms?
    >> >
    >> > If that can't be done, what is the correct way to design a long (3-5
    >> > page)
    >> > form?
    >> >
    >> > NB

    >>
    >>
    >>
     
  8. NB

    NB
    Expand Collapse
    Guest

    John,
    I have the same problem in reports - it can print hundreds of pages of
    records, but the layout will only allow 22" in the detail section. My fields
    take up 3 pages, because I have to give enough space for the reviewers to
    hand-write comments in each section.

    The purpose of this form (or report) is for Site Reviewers to take them to
    review a site against criteria. The top portion must pre-populate with the
    site data (name, address, etc.). The rest are fields with blanks and comment
    sections for the reviewers to fill out (by hand) as they walk the site.

    I can create the form for inputting the hand-written data into the dbase -
    that isn't a problem, but the "pre-populated" form to give to the reviewers
    is 3 pages long. Your thoughts?
    NB

    "John Vinson" wrote:

    > On Fri, 9 Jun 2006 09:14:01 -0700, NB <NB@discussions.microsoft.com>
    > wrote:
    >
    > >If that can't be done, what is the correct way to design a long (3-5 page)
    > >form?

    >
    > If you want to print the data, use a Report. Forms are designed for
    > onscreen viewing and editing (tab pages let you share screen space);
    > they're not optimized for printing. Reports are.
    >
    > John W. Vinson[MVP]
    >
     
  9. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    NB wrote:
    > John,
    > I have the same problem in reports - it can print hundreds of pages of
    > records, but the layout will only allow 22" in the detail section. My
    > fields take up 3 pages, because I have to give enough space for the
    > reviewers to hand-write comments in each section.
    >
    > The purpose of this form (or report) is for Site Reviewers to take
    > them to review a site against criteria. The top portion must
    > pre-populate with the site data (name, address, etc.). The rest are
    > fields with blanks and comment sections for the reviewers to fill out
    > (by hand) as they walk the site.
    >
    > I can create the form for inputting the hand-written data into the
    > dbase - that isn't a problem, but the "pre-populated" form to give to
    > the reviewers is 3 pages long. Your thoughts?
    > NB


    TestBoxes on reports that have lots of data in them can be made one line
    tall and then have CanGrow set to yes. The fact that your report will have
    large fields does not mean that you have to account for all of that space in
    design view. You can also add additional Grouping Sections
    (headers/footers). The 22 inch limit is per section, not per report.


    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
  10. NB

    NB
    Expand Collapse
    Guest

    Thank you Susan. This will work. I was hoping to keep it all within Access
    for simplicity's sake.

    Sometimes I am amazed at the simple issues that a robust program like Access
    can't handle, e.g. giving more than 22" layout space, or giving the option of
    printing tab controls in order!

    The tabs would be a perfect solution for either forms or reports - but if
    you can't print them as a group, they are far less useful than they could be!
    Just venting.

    I appreciate your help. Have a great day.
    NB

    "SusanV" wrote:

    > Ah, now I see your problem - I had a similar one for field techs.
    > The solution I used was to create a Word Merge Document to print - Word will
    > let you do whatever it is you need to do.
    >
    > Open the table or Query the form is based on, go to tools>Office Links>
    > Merge it with MS Word. Select the fields from the left side dropdown,
    > inserting whatever text you want for the labels, add blank lines (or
    > underlined spaces if you like) for the fill-in sections, page breaks,
    > company logo, images, whatever. Save it someplace. Then click on Merge, and
    > select new document, and you should be good to go!
    >
    >
    > --
    > hth,
    > SusanV
    >
    >
    >
    > "NB" <NB@discussions.microsoft.com> wrote in message
    > news:81D37BD1-D834-44BB-87A2-F062243F2169@microsoft.com...
    > > Susan,
    > > I have the same problem in reports - it can print hundreds of pages of
    > > records, but the layout will only allow 22" in the detail section. My
    > > fields
    > > take up 3 pages, because I have to give enough space for the reviewers to
    > > hand-write comments in each section.
    > >
    > > The purpose of this form (or report) is for Site Reviewers to take them to
    > > review a site against criteria. The top portion must pre-populate with the
    > > site data (name, address, etc.). The rest are fields with blanks and
    > > comment
    > > sections for the reviewers to fill out (by hand) as they walk the site.
    > >
    > > I can create the form for inputting the hand-written data into the
    > > base -
    > > that isn't a problem, but the "pre-populated" form to give to the
    > > reviewers
    > > is 3 pages long. Your thoughts?
    > >
    > > "SusanV" wrote:
    > >
    > >> You should print reports, not forms. Reports can go hundreds of pages,
    > >> and
    > >> can be formatted to look much nicer than forms.
    > >> --
    > >> hth,
    > >> SusanV
    > >>
    > >> "NB" <NB@discussions.microsoft.com> wrote in message
    > >> news:C0FF147A-48F6-45F3-92C3-7F318E65B092@microsoft.com...
    > >> >I have a 3 page form. Because Access only allows 22" in length, I put
    > >> >each
    > >> > page on a tab. I need to print tab1, tab2, tab3 all at once, before
    > >> > going
    > >> > to
    > >> > the next record. How can I print multi-tabbed forms?
    > >> >
    > >> > If that can't be done, what is the correct way to design a long (3-5
    > >> > page)
    > >> > form?
    > >> >
    > >> > NB
    > >>
    > >>
    > >>

    >
    >
    >
     
  11. SusanV

    SusanV
    Expand Collapse
    Guest

    Well, it *uses* Word, but at least you can do it all from within Access, if
    that's any consolation.

    ;-)

    Glad to help any time, good luck!

    SusanV

    "NB" <NB@discussions.microsoft.com> wrote in message
    news:2F25587A-F9F5-4CD4-A1DA-0898428B3CD9@microsoft.com...
    > Thank you Susan. This will work. I was hoping to keep it all within Access
    > for simplicity's sake.
    >
    > Sometimes I am amazed at the simple issues that a robust program like
    > Access
    > can't handle, e.g. giving more than 22" layout space, or giving the option
    > of
    > printing tab controls in order!
    >
    > The tabs would be a perfect solution for either forms or reports - but if
    > you can't print them as a group, they are far less useful than they could
    > be!
    > Just venting.
    >
    > I appreciate your help. Have a great day.
    > NB
    >
    > "SusanV" wrote:
    >
    >> Ah, now I see your problem - I had a similar one for field techs.
    >> The solution I used was to create a Word Merge Document to print - Word
    >> will
    >> let you do whatever it is you need to do.
    >>
    >> Open the table or Query the form is based on, go to tools>Office Links>
    >> Merge it with MS Word. Select the fields from the left side dropdown,
    >> inserting whatever text you want for the labels, add blank lines (or
    >> underlined spaces if you like) for the fill-in sections, page breaks,
    >> company logo, images, whatever. Save it someplace. Then click on Merge,
    >> and
    >> select new document, and you should be good to go!
    >>
    >>
    >> --
    >> hth,
    >> SusanV
    >>
    >>
    >>
    >> "NB" <NB@discussions.microsoft.com> wrote in message
    >> news:81D37BD1-D834-44BB-87A2-F062243F2169@microsoft.com...
    >> > Susan,
    >> > I have the same problem in reports - it can print hundreds of pages of
    >> > records, but the layout will only allow 22" in the detail section. My
    >> > fields
    >> > take up 3 pages, because I have to give enough space for the reviewers
    >> > to
    >> > hand-write comments in each section.
    >> >
    >> > The purpose of this form (or report) is for Site Reviewers to take them
    >> > to
    >> > review a site against criteria. The top portion must pre-populate with
    >> > the
    >> > site data (name, address, etc.). The rest are fields with blanks and
    >> > comment
    >> > sections for the reviewers to fill out (by hand) as they walk the site.
    >> >
    >> > I can create the form for inputting the hand-written data into the
    >> > base -
    >> > that isn't a problem, but the "pre-populated" form to give to the
    >> > reviewers
    >> > is 3 pages long. Your thoughts?
    >> >
    >> > "SusanV" wrote:
    >> >
    >> >> You should print reports, not forms. Reports can go hundreds of pages,
    >> >> and
    >> >> can be formatted to look much nicer than forms.
    >> >> --
    >> >> hth,
    >> >> SusanV
    >> >>
    >> >> "NB" <NB@discussions.microsoft.com> wrote in message
    >> >> news:C0FF147A-48F6-45F3-92C3-7F318E65B092@microsoft.com...
    >> >> >I have a 3 page form. Because Access only allows 22" in length, I put
    >> >> >each
    >> >> > page on a tab. I need to print tab1, tab2, tab3 all at once, before
    >> >> > going
    >> >> > to
    >> >> > the next record. How can I print multi-tabbed forms?
    >> >> >
    >> >> > If that can't be done, what is the correct way to design a long (3-5
    >> >> > page)
    >> >> > form?
    >> >> >
    >> >> > NB
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>
     
  12. NB

    NB
    Expand Collapse
    Guest

    Thank you, Rick.
    NB

    "Rick Brandt" wrote:

    > NB wrote:
    > > John,
    > > I have the same problem in reports - it can print hundreds of pages of
    > > records, but the layout will only allow 22" in the detail section. My
    > > fields take up 3 pages, because I have to give enough space for the
    > > reviewers to hand-write comments in each section.
    > >
    > > The purpose of this form (or report) is for Site Reviewers to take
    > > them to review a site against criteria. The top portion must
    > > pre-populate with the site data (name, address, etc.). The rest are
    > > fields with blanks and comment sections for the reviewers to fill out
    > > (by hand) as they walk the site.
    > >
    > > I can create the form for inputting the hand-written data into the
    > > dbase - that isn't a problem, but the "pre-populated" form to give to
    > > the reviewers is 3 pages long. Your thoughts?
    > > NB

    >
    > TestBoxes on reports that have lots of data in them can be made one line
    > tall and then have CanGrow set to yes. The fact that your report will have
    > large fields does not mean that you have to account for all of that space in
    > design view. You can also add additional Grouping Sections
    > (headers/footers). The 22 inch limit is per section, not per report.
    >
    >
    > --
    > Rick Brandt, Microsoft Access MVP
    > Email (as appropriate) to...
    > RBrandt at Hunter dot com
    >
    >
    >
     

Share This Page