[AccessD] Re: How to set flag

Chester,

Create a table called tsys_SystemSettings
Have one field in it  LastRunDate, Date datatype

After running your process, replace the last run date
with the current date.  When opening the
database, check to see if it is today() or
LastRunDate + 7 then take the appropriate action.
Today - Ignore
Not LastRunDate + 7 - Ignore
= LastRunDate + 7 - Run again

Robert

At 10:48 AM 10/2/2003 -0500, you wrote:
>Date: Thu, 2 Oct 2003 10:41:37 -0500
>From: "Kaup, Chester A" <kaupca at chevrontexaco.com>
>Subject: [AccessD] FW: How to set flag
>To: accessd at databaseadvisors.com
>Message-ID:
> 
><193572B4E0FC1744BEDFEE63F82CEC9E011E3ED5 at bocnte2k4.boc.chevrontexaco.net>
>
>Content-Type: text/plain; charset="us-ascii"
>
> > I have a database with some code that runs only on Wednesday. No
> > problem do that with If Weekday(DATE) = 4 .
> > What I need to do is set some kind flag so that the first time the
> > database opens on Wednesday the code runs but not on subsequent
> > openings. I am at a loss of how to do this. Maybe I need to track
> > openings of database? Thanks
> >
> > No trees were killed in the sending of this message. However a large
> > number of electrons were terribly inconvenienced.