<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>FW: How to set flag</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=914051116-02102003><FONT face=Verdana size=2>Everytime it opens
you could check the day and the flag. If the day <> Wednesday then
set the flag = false (or whatever) and exit the function. If day =
Wednesday and flag = false then run the code and set the flag = true.
Next time day = Wednesday and flag = true so skip the code.</FONT></SPAN></DIV>
<DIV><SPAN class=914051116-02102003><FONT face=Verdana
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=914051116-02102003><FONT face=Verdana size=2>The reason I say
to set the flag = false any other day of the week is that this would almost
gaurantee that the flag is reset even if the app isn't opened every
day.</FONT></SPAN></DIV>
<DIV><SPAN class=914051116-02102003><FONT face=Verdana
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=914051116-02102003><FONT face=Verdana size=2>Of course, to
avoid that you could store the number of the week when the code last ran and
compare it to the the new week number on the next Wednesday. If the week
numbers do not match then run the code.</FONT></SPAN></DIV>
<P><FONT size=2>Reuben Cummings<BR>GFC, LLC<BR>phone: 812.523.1017<BR>email:
reuben@gfconsultants.com</FONT> </P>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Kaup, Chester
A<BR><B>Sent:</B> Thursday, October 02, 2003 10:42 AM<BR><B>To:</B>
accessd@databaseadvisors.com<BR><B>Subject:</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>