Impact a Range of Records

[Gee...]

I have records, displayed in a form, that are labeled as page numbers.

The pages are either accepted or rejected by using a check box, check the
box for accepted, unchecked means rejected. If rejected they go for
reprinting.

I need to be able to check the check box in a group....like a dialog box
that allows the user to accept pages 102 through 300 and the check box would
be checked for those pages, or records, if it has to go by record number that
would be fine too.

Thank you in advance for your help.
Gee

 

[Gee...]

I guess no one knows?

How about this:

On a continuous form I have a group of records showing that were chosen with
a Between [Start]and[Finish] in a Query.

I need a button to click that would change put "Accepted" in the [Status]
field on all of those records at once.

Help?
Gee

 

[steve]

Gee,

I am not the most knowledgeable one on here, but it seems like the following
should work.

1. Create a button to run a parameter query that you would give the range of
page numbers to. ie Between [Beginning Page Number] and [Ending Page Number]

2. In the OnClick event of the button put code to populate a recordset with
the query results. This will be after the code that runs the query.

3. Loop through the recordset, setting the checkbox to true or -1.

HTH

Steve

 

[Gee...]

That sounds like what I need to happen.
Am I pushing it by asking for the code or where to find and example?

Gee,

I am not the most knowledgeable one on here, but it seems like the following
should work.

1. Create a button to run a parameter query that you would give the range of
page numbers to. ie Between [Beginning Page Number] and [Ending Page Number]

2. In the OnClick event of the button put code to populate a recordset with
the query results. This will be after the code that runs the query.

3. Loop through the recordset, setting the checkbox to true or -1.

HTH

Steve

I have records, displayed in a form, that are labeled as page numbers.

The pages are either accepted or rejected by using a check box, check the
box for accepted, unchecked means rejected. If rejected they go for
reprinting.

I need to be able to check the check box in a group....like a dialog box
that allows the user to accept pages 102 through 300 and the check box
would
be checked for those pages, or records, if it has to go by record number
that
would be fine too.

Thank you in advance for your help.
Gee