Thought Process

[Guest]

Good morning

I have a need to create a report that shows a random 10% of records for a
particular date. This is sorted thanks to Ofer Cohen and Jerry Whittle. I
then need to lock a form until the records selected on the above report have
been reviewed.
My thought process to achieve the above is as follows

1 Query for selection of 10% of random records
2 Update query to create a value in the table against the records selected
in 1, (this value would be 1)
3 Code in current event of Form which says that if there is a value of 1 in
the field in point 2 show warning message YES NO.
4 If yes clicked go to new form which displays records with value of 1 in
the field in point 2. The form has a checkbox to be clicked after record has
been reviewed and a further field date and time stamped once checkbox
clicked(this is for Audit purposes). (Idea of checkbox being checked is that
the value in the field in point 2 will change to -1 rather than 1.
5 If no is clicked in point 3 then original form is closed.

If anyone can understand the above then please advise if this seems the best
way to achieve my ends or if there would be a better way of achieving my ends.

Many thanks

Richard

 

[Guest]

I "think" you may be on the right lines - but a few point crop up to me

1 Query for selection of 10% of random records

Sounds fine (see http://www.mvps.org/access/queries/qry0011.htm )

2 Update query to create a value in the table against the records selected
in 1, (this value would be 1)

I think I may be temped to use set value on a form based on the ramdom query
(but thats just me).
But I "would" set the value to 0 (not 1) and format the field holding this
as yes/no.

3 Code in current event of Form which says that if there is a value of 1 in
the field in point 2 show warning message YES NO.

See above
I also would have the message something like
Do you want to >>>whatever or comeback to this task later
I would not put it OnLoad - just if any of the ramdom records have not been
viewed
Sort of
If me.ABC = 0 then
Text
End If

4 If yes clicked go to new form which displays records with value of 1 in
the field in point 2. The form has a checkbox to be clicked after record has
been reviewed and a further field date and time stamped once checkbox
clicked(this is for Audit purposes). (Idea of checkbox being checked is that
the value in the field in point 2 will change to -1 rather than 1.

Sounds OK to me (not options should be either 0 or -1 not 0 or 1)

5 If no is clicked in point 3 then original form is closed.

Don't know - up to you that bit