bml337 via AccessMonster.com wrote:
Quote:
I need to create a supervisory log for my clients. The log table has the
following fields date, checkbox and notes. now for the tricky part... one
log is weekly and should be generated every monday. i have a similar log
that will be run on the first of each month.
>
so i need a record auto generated every Monday of the week and another
generated on the first of every month... these will be in two separate tables.
. also possible to auto email to the client???
>
from there i will email that record w/access 2007 to the client so they can
fill out the rest of the information. then i can append the record back the
DB and create a report.
>
suggestions please and thanks in advance.
>
bl
>
I might have a small table with only 1 record. Two fields could be
called Monday and FirstOfMonth. When the app opens, check those fields.
You might want to prefill them with the last Monday and the date of
the last 1stofmonth.
You'd need some logic applied to it. For example, a few US holidays are
on Monday. So the chances of people being off work that day are high.
So add 7 days to the last Monday. If today is equal or greater that
date then you need to create a Monday record. Now add a month (see
DateAdd in help) to the 1stofmonth and see if the date is greater/equal
to that date. If either case is true, add the respective record.
Simply adding a record does nothing. Who's in charge of that record?
You? Or another worker. So even if you add a record somebody needs to
be made aware that a record has been created and notes need to be filled
in and then someone needs to email the record.
So the above is just a suggestion, logic needs to be defined.
