creating logs by date

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

--
brandon

Message posted via http://www.accessmonster.com

Re: creating logs by date

bml337 via AccessMonster.com wrote:
> 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.

Re: creating logs by date

Im in charge and currently use excel. I know access has the email feature
and the only thing i need to do is make sure the date is correct and is sent
to each client for them to populate (does not have to be sent on the actual
date). Just trying to find the right way to do this... i know access can be
a very complex system

thanks

Salad wrote:
>> 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
>[quoted text clipped - 12 lines]
>>
>> 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.

--
brandon

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