How set up repeating record in Access 2007 (monthly, quarterly, et

[Doohickeys]

I created a simple database to track suspenses/actions. If an action is
recurring such as monthly, quarterly, bi-annually, or yearly, how do I get a
"reminder" or a record copied for the next time period? For example, if I am
working on a monthly record in February, how do I trigger it to come up
automatically - or remind me - in February to make a record for March?

I would REALLY rather have it as follows:
• Copy the record I'm working on (example, the monthly record for February)
• Create a new record (the record for March)
• Change the action # to the next # (AM-102 would become AM-103)
• Change the due date (from February 15, 2010 to March 15, 2010)

I hope this isn't too confusing! THANK YOU!

 

[pietlinden]

I created a simple database to track suspenses/actions.  If an action is
recurring such as monthly, quarterly, bi-annually, or yearly, how do I get a
"reminder" or a record copied for the next time period?  For example, if I am
working on a monthly record in February, how do I trigger it to come up
automatically - or remind  me - in February to make a record for March?

I would REALLY rather have it as follows:
• Copy the record I'm working on (example, the monthly record for February)
• Create a new record (the record for March)
• Change the action # to the next # (AM-102 would become AM-103)
• Change the due date (from February 15, 2010 to March 15, 2010)

I hope this isn't too confusing!  THANK YOU!

use an append query with a calculated value for the next month's due
date. Then you'd have to run in somehow... like on the click event of
a button.