[AccessD] FW: How to set flag

FW: How to set flagSimplest thing, I think would be to create a one field table where, when you run the code, it stores the current date.  Then every time the database is opened you could check that date and run the code if it hadn't already been run that day.

Rocky

  ----- Original Message ----- 
  From: Kaup, Chester A 
  To: accessd at databaseadvisors.com 
  Sent: Thursday, October 02, 2003 8:41 AM
  Subject: [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.






------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20031002/72b8821d/attachment-0001.html>