Reoccurring log D/W/M

I have created a database that needs to track certain logs on a daily, weekly
or monthly basis.

my question, how can i have a record automatically created every monday for
example.

fields are simple- Week of, reviewed (yes/no) and notes

so i would like the above fields to be created for my clients log and the
only field that should be populated is the week of.

thank for any help.

--
brandon

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-ac cess/200710/1

Re: Reoccurring log D/W/M

On Oct 31, 12:49 pm, "bml337 via AccessMonster.com"
wrote:
> I have created a database that needs to track certain logs on a daily, weekly
> or monthly basis.
>
> my question, how can i have a record automatically created every monday for
> example.
>
> fields are simple- Week of, reviewed (yes/no) and notes
>
> so i would like the above fields to be created for my clients log and the
> only field that should be populated is the week of.
>
> thank for any help.
>
> --
> brandon
>
> Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.asp x/databases-ms-access/2007...

I would attack this in a different manner. I would only create a
review record when the user conducts a review and date/time stamp the
review. Then you can query/report/filter on the review records to see
when reviews were performed. If you try to create records say every
monday, you have to control what happens if no one runs the database
on a monday on a given week or even worse for several consecutive
mondays. It is unsound to assume that 'the database is always run on
mondays'.