How could I 'flag up' dates

[tomharper]

Sorry, I tried searching the forums with no luck.

What I need to do is.

I have a table with a field called intervention day, the user then types in that field a date, pretty simple huh.

Well anyway I need the system to some how alert the user when that date comes, either through an information box or whatever.

thanks for any help,
tom harper

 

[lessthanme5]

Example

Here is an example database which user a calendar format that has that function

Its a bit confusing, but you can take what you want or need from it and then delete it.

http://www.candace-tripp.com/download/MiniCalendar.zip

 

[neileg]

Run a query with the system date function Date() as the criterion in your intervention day field. You could set this to run each time the databse is opened, or allow the user to run it whenever they needed to. If you wanted to find those in the coming week, you could use Between Date() and Date()+7 as the criterion.

 

[tomharper]

Run a query with the system date function Date() as the criterion in your intervention day field. You could set this to run each time the databse is opened, or allow the user to run it whenever they needed to. If you wanted to find those in the coming week, you could use Between Date() and Date()+7 as the criterion.

This didnt work??

 

[neileg]

In what way did it not work? Can you post the SQL behind your query (open the query in design view and switch to SQL view. Paste that here.)

 

[The_Doc_Man]

First, time for a concept check.

The system DATE function usually returns a Date-formatted value. When you store dates from a form, if you store them as text, you have no dates in the tables. Only TEXT REPRESENTATIONS of dates. Comparing a date field to a text field usually doesn't work too well. So data storage format counts.

Second, time for an algorithm check.

Assuming you resolve the problem of date formatting, you need to consider what happens if nobody turns on the computer on the day that an event becomes "due." I.e. you need to establish "overdue" rules.

Third, your "overdue" rules can cause more headaches unless you have a way to "turn off" the event in question. I.e. to say "this event has been handled."