Shawny
09-22-2004, 10:31 AM
Hi,
I am making a database to balance my checkbook that enters schedualed transactions. I want to type in a starting date, and then run code to add a new record every 30 days after the date.
I know how to write a macro to add the new record. I do not know how to tell Access to run the code automatically every 30 days - and if I open the database after the 30 days, run it then, and only once.
Don't ask for much, do I?
I am making a database to balance my checkbook that enters schedualed transactions. I want to type in a starting date, and then run code to add a new record every 30 days after the date.
I know how to write a macro to add the new record. I do not know how to tell Access to run the code automatically every 30 days - and if I open the database after the 30 days, run it then, and only once.
Don't ask for much, do I?