Is there a flag function in Access that can auto clear daily?

[mcf747]

After a user performs a certain action, in this case submit a record. I want
to put a flag in the useres tabel so they canot perfor this action untill the
flag is cleared. I want the flag to clear by itsef daily. The easist way to
do this that I know of is to place a value such as "Y" in a colom of the
users tabel andthen have the filter for the performing form to look for only
null values in the users tabel i.e. without the "Y" but I cant figure out how
to clear this value every day at a certain time.

Thanks to anyone who can help me.

Matthew
mcf747

 

[Rick Brandt]

After a user performs a certain action, in this case submit a record.
I want to put a flag in the useres tabel so they canot perfor this
action untill the flag is cleared. I want the flag to clear by itsef
daily. The easist way to do this that I know of is to place a value
such as "Y" in a colom of the users tabel andthen have the filter for
the performing form to look for only null values in the users tabel
i.e. without the "Y" but I cant figure out how to clear this value
every day at a certain time.

Thanks to anyone who can help me.

Matthew
mcf747

Instead of a "Y" store the date. Then your filter can be to allow the
action on all records with a Null value OR a value earlier than the current
date. No clearing necessary.