Trying to find away to go into a block of code only once

[itm]

Hi,



I have code that I only want to do on the first of every month once. I have it is set that if the day of the month is the first, go into this code, when they they load the form; and it works great. The problem is they may load this for numerus times on that day, and they may even close the Access application and reopen it on tha t day; causing it to run the code again. Is there away that I can just have it run once no matters what on the first of the month?

Thank you
itm

[Robeen]

Not sure if this is the best way to do this, but you could have a little table that has just one field - that stores either 'Done' or 'Not Done' - [or just 'True' or 'False'].
When the form Loads:
1. Check if it is the 1st of the month.
2. If it IS the 1st - Check that field in the Table to see if the value in there is True or False.
3. If it is False - Run your code - and then set the Value to True.
4. If it is NOT the 1st of the month- Check the field in the Table and if the value is True - set it to False so that the next time the 1st of the month comes around, your code will fire again.
Hope this helps - or at least gives you some ideas!

[itm]

Thanks that sounds like it would do it.
itm