<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>FW: How to set flag</TITLE>
<META content="MSHTML 5.50.4930.1700" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=406515815-02102003><FONT face=Arial color=#0000ff size=2>hallo
Chester,</FONT></SPAN></DIV>
<DIV><SPAN class=406515815-02102003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=406515815-02102003><FONT face=Arial color=#0000ff size=2>For
this sort of thing I use a table with a date field,</FONT></SPAN></DIV>
<DIV><SPAN class=406515815-02102003><FONT face=Arial color=#0000ff size=2>when I
run the code or update data I write the date to this field</FONT></SPAN></DIV>
<DIV><SPAN class=406515815-02102003><FONT face=Arial color=#0000ff size=2>then
in the code check to see if todays date = the date in the
field.</FONT></SPAN></DIV>
<DIV><SPAN class=406515815-02102003><FONT face=Arial color=#0000ff size=2>if
true exit sub</FONT></SPAN></DIV>
<DIV><SPAN class=406515815-02102003><FONT face=Arial color=#0000ff size=2>if
false run code</FONT></SPAN></DIV>
<DIV><SPAN class=406515815-02102003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=406515815-02102003><FONT face=Arial color=#0000ff
size=2>hth</FONT></SPAN></DIV>
<DIV><SPAN class=406515815-02102003><FONT face=Arial color=#0000ff
size=2>alun</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Ursprüngliche Nachricht-----<BR><B>Von:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>Im Auftrag von </B>Kaup,
Chester A<BR><B>Gesendet:</B> Donnerstag, 2. Oktober 2003 17:42<BR><B>An:</B>
accessd@databaseadvisors.com<BR><B>Betreff:</B> [AccessD] FW: How to set
flag<BR><BR></FONT></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>I have a database with some code that runs only on
Wednesday. No problem do that with If Weekday(DATE) = 4 . </FONT><BR><FONT
face=Arial size=2>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</FONT></P>
<P><FONT face="Times New Roman" size=1>No trees were killed in the sending of
this message. However a large number of electrons were terribly
inconvenienced.</FONT><BR></P><BR></BLOCKQUOTE></BODY></HTML>