AW: [AccessD] FW: How to set flag

hallo Chester,
 
For this sort of thing I use a table with a date field,
when I run the code or update data I write the date to this field
then in the code check to see if todays date = the date in the field.
if true exit sub
if false run code
 
hth
alun

-----Ursprüngliche Nachricht-----
Von: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]Im Auftrag von Kaup, Chester A
Gesendet: Donnerstag, 2. Oktober 2003 17:42
An: accessd at databaseadvisors.com
Betreff: [AccessD] FW: How to set flag



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.



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20031002/0e10802b/attachment-0001.html>