Auto Entry for Records

[JonathanT]

Is it possible to schedule a record(s) to be entered at a set interval? For instance I have a database where I enter expenses. There are several entries that are monthly, the same amount, and occur on the same date each month. Is it possible to set up some king of automatic entry into a database table?

[Welshgasman]

Well the way Quicken does it is to store the transactions, and when the date is reached add them to your particular account and increment the date for the next payment be it weekly, monthly 4 weeks etc.
You can replicate that.?

[Gicu]

You can add a table that holds your monthly expenses, their amount and due date (the day like in 15 of the month). Then write a VBA function (that can be called from the AutoExec macro or from the db's opening form) that checks if the current month expenses have been already added and adds them via an append query if not.

Cheers,

[JonathanT]

Thanks for the information. I'm not great a writing code but I will give it a shot

[Welshgasman]

Well the simplest would be an Insert query using your Monthly table as the Select data.