Monthly Programming

[ekaragew]

I work as a cashier on a clinic where old people stay. Every month each of them have to pay a fee. So i created a database where at the end o querry informs me who hasn't pay. But at the beginning of the month i have to make a new entry for everyone as unpaid and whenever i get the money i alter the mark note as paid.

Is there a way that access at the 1st of each month to create the above entry (unpaid) by itself, and afterwards i will change it myself as "paid" when i get the money?

Thank you...

[June7]

Maybe with a Timer event but I've never used this. Look at http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

The Timer event could have code that checks the current date and if 1st of month run a procedure that adds records to table.

Or try something like what is discussed in this thread https://www.accessforums.net/access/...ail-14499.html