Welcome to SPN

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

Sign Up Now!

Access

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

Tags:
  1. Nancy

    Nancy
    Expand Collapse
    Guest

    I have a report for mailing labels. I would like to be able to print out
    only specific labels. In my form, I entered a checkbox, and if that field
    has a check in it, I want the report to skip over that label, not printing
    it. I know NOTHING about expressions or anything detailed and am wondering
    if someone can give me some help. Thanks!
     
  2. Loading...


  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 9 May 2006 13:50:03 -0700, Nancy
    <Nancy@discussions.microsoft.com> wrote:

    >I have a report for mailing labels. I would like to be able to print out
    >only specific labels. In my form, I entered a checkbox, and if that field
    >has a check in it, I want the report to skip over that label, not printing
    >it. I know NOTHING about expressions or anything detailed and am wondering
    >if someone can give me some help. Thanks!


    The checkbox on the Form doesn't really help. A Form doesn't *contain*
    any data - it lets you view and edit data in a Table.

    You'll need instead to add a Yes/No field in the Table upon which your
    report is based, and bind this field to the form checkbox. You can
    then base the Report on a Query (rather than directly on the table),
    using a criterion of False on this field.

    John W. Vinson[MVP]
     
  4. Nancy

    Nancy
    Expand Collapse
    Guest

    I did add a Yes/No field to the table also. How do I bind it to the checkbox
    on the form, and how/where do I add anything to criteria? I have been
    working on this for hours and just can't figure it out.

    Thanks so much for your time!


    "John Vinson" wrote:

    > On Tue, 9 May 2006 13:50:03 -0700, Nancy
    > <Nancy@discussions.microsoft.com> wrote:
    >
    > >I have a report for mailing labels. I would like to be able to print out
    > >only specific labels. In my form, I entered a checkbox, and if that field
    > >has a check in it, I want the report to skip over that label, not printing
    > >it. I know NOTHING about expressions or anything detailed and am wondering
    > >if someone can give me some help. Thanks!

    >
    > The checkbox on the Form doesn't really help. A Form doesn't *contain*
    > any data - it lets you view and edit data in a Table.
    >
    > You'll need instead to add a Yes/No field in the Table upon which your
    > report is based, and bind this field to the form checkbox. You can
    > then base the Report on a Query (rather than directly on the table),
    > using a criterion of False on this field.
    >
    > John W. Vinson[MVP]
    >
     
  5. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Wed, 10 May 2006 07:21:02 -0700, Nancy
    <Nancy@discussions.microsoft.com> wrote:

    >I did add a Yes/No field to the table also. How do I bind it to the checkbox
    >on the form,


    Open the Form in design view. Select the Checkbox. View its
    Properties; set the "Control Source" property - first one on the Data
    tab - to the name of the field.

    You might have to also view the properties of the Form itself (click
    the little square at the upper left intersection of the rulers), view
    its Recordsource property, and add the new yes/no field to the Query
    upon which the form is based.

    >and how/where do I add anything to criteria? I have been
    >working on this for hours and just can't figure it out.


    Create a new Query based on your table. Select all the fields. Put the
    word False on the Criteria line under this yes/no field. Save the
    Query, and base your mailing label report on the query.

    John W. Vinson[MVP]
     

Share This Page