How do I set up a reoccurring action in Access?

[Guest]

I would like to set up reoccurring payments, like utilities without having to
enter one entry for each occurance. Any ideas? Thanks!!

 

[Rick B]

We would have to know a lot more about the structure of your tables before
we could help you. You could create code tied to a form that allows the
user to enter the information including the number of recurrences and the
frequency, then the table could be appended with records.

Without knowing about your database structure, it would be hard for us to
give you a specific answer.

 

[Guest]

Sorry, I'm a newb just setting up the database, but didn't want to spend too
much time on it if this wasn't possible (Access class instructor didn't
know). So far I have three whoppin' tables, one for payments, another for
payees and the third is categories. Structure is very typical... need more
detail?

 

[Guest]

Perhaps it would be more appropriate just to request and example of the
string of code. If I see that, I can figure it out.
Thanks again, any help is greatly appreciated.

 

[George Nicholson]

Of course it would be possible to set up a recurring payments feature in
your db, but it would be a custom job. To set up a full fledged Recurring
Payments feature (like Money or Quicken) you'd need at least one additional
table (RecurringTransactionList w/Frequency, NextDueDate, Amount, Payee,
etc), a mechanism to copy/transform a RecurringTransaction record into a
Payment record (automatically when date comes? or only if you check it
off?)... and then you need to update the NextDueDate of the RecurringTrx
you just transformed per the specified Frequency... and then...and then...

Good luck,

HTH,