Validate/check entered values

I

Igor G.

I have subform with coumns: Date, Time and Check (CheckBox).
How to check all CheckBoxes in subform with specific date and time?

Example: I want to check all data from 3.7.2006 in time 7:00 to 11:00
With this code I want to validate entered values (about 200 rows) from my
employees and publish to other if have my check OK.

Thanks!
 
S

Steve Schapel

Igor,

You can make and run an Update Query. If you are doing this in design
view of the query, select Update from the Query menu, and then in the
Update To row of the query design grid, in the Check column, enter...
-1
Then, if I understand you correctly, in the Criteria of the Date column,
you would put...
=#3/07/2006#
Click to expand...
.... and in the Criteria of the Time column...
Between #7:00# And #11:00#

By the way, as an aside, 'date' and 'time' are "reserved words" (i.e.
have a special meaning) in Access, and as such should not be used as the
names of fields or controls. I would advise changing this if possible.
 
I

Igor G.

Thanks Steve, this works OK!


„Steve Schapel“ said:
Igor,

You can make and run an Update Query. If you are doing this in design
view of the query, select Update from the Query menu, and then in the
Update To row of the query design grid, in the Check column, enter...
-1
Then, if I understand you correctly, in the Criteria of the Date column,
you would put...
.... and in the Criteria of the Time column...
Between #7:00# And #11:00#

By the way, as an aside, 'date' and 'time' are "reserved words" (i.e.
have a special meaning) in Access, and as such should not be used as the
names of fields or controls. I would advise changing this if possible.
Click to expand...
 
Top