Software

Ask something
Discussion Locked

MS Access w/ Reoccuring Events

0 helpful
3 replies

by jgreer

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am working on a maintenance database and have some records that must be updated every week, month, year, etc. How can I program a database to automatically remind the users of these tasks with these reminders? I know its possible as the current database has these, but cannot figure out how to implement it.

3 replies

by zencoyote

I think the way I would do it is to build a table with a field to hold the date/time of the most recent update of the record. Next I would build a query (or write SQL) that returns the maximum date from this table. Then I would put some code in the open event for the applicable form that would retrieve the maximum date from the query. The code would do a little math and return true if the record needs to be updated and false if it doesn't. If true (record needs updating) you could have the codeopen a form to gather updated info, or give a message, whatever works. Hope this helps.

This discussion is closed to new replies.