I am designing a database to balance my checkbook. How do I put in schedualed transactions?
I know how to add the new record. I don't know how to tell Access when to do it, and to not do it more than once a month.
Create a new table to keep track of when to run the append scheduled transactions code.
tblScheduledTrans
ScheduledDt (date) (primary key)
CompleteFlg (yes/no) (default = No)
Add the first row to start the process. So if you want your transactions to be appended on the first, make the date = 10/1/04
Create a query that selects the Max(ScheduledDt) where ScheduledDt <= Date() and CompleteFlg = Yes. If the query returns a record:
run your code to generate the scheduled transactions
update the CompleteFlg to Yes
Append a new row for the following month. Use DateAdd() to add 1 month to ScheduledDt
Otherwise don't do anything.
Warning, Warning Will Robinson! Danger! Danger! I've never used the bullet list feature before. Be aware that if you use it, it DELETES anything that you've already written!!!!
