Close record and advance next record after day end

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kyle - 31 Oct 2005 05:45 GMT

How do I make a record close and advance to next record when a day is ended.
I like to have a record close and lock out (not allow user to enter or change
the field in previous record but start automatice advance to new record on
next day) after a day is ended. The user has to enter all the field again
starting new record next day.

any suggestion. Thanks

Reply to this Message

Jeff Boyce - 31 Oct 2005 14:15 GMT

Kyle

We're not there, and we can't see your data structure, so any suggestion is
going to be generic, not specific.

If your form includes a validation check to ensure that records with
"yesterdays'" dates are not edited, would that do it?

Signature

Regards

Jeff Boyce
<Office/Access MVP>

> How do I make a record close and advance to next record when a day is ended.
> I like to have a record close and lock out (not allow user to enter or change
[quoted text clipped - 3 lines]
>
> any suggestion. Thanks

Reply to this Message