Flag a future date

[Mat]

I have a table called TASKS.
I want to set up some code that will insert a table field
text (eg TASK) into a prompt message box BUT only after a
time I specify in another field of the table (eg DUE_DATE)
What code is needed - and is there an option for
a 'snooze' facility to add on say a set random period ?
Any help would be really appreciated. Thanks.

 

[Nikos Yannacopoulos]

Mat,

This can be done by conditionally showing the prompt if current date is
greater than or equal to the date in the DUE_DATE field. You're not saying
though which event is going to fire it. Is it while browsing through table
records in a form? Is it on database open, without having to open and browse
through a form?

In the former case, it would be somethig like:

If Me.DUE_DATE >= Date() Then
msgbox Me.TASK
End If

fired by the form's On Current event.

In the latter case, it would require a select query on the table, returning
the TASK plus any other required field, with a criterion >=Date() on the
DUE_DATE field, and opened through an OpenQuery action in an Autoexec macro.

Is it something else maybe?

HTH,
Nikos

fired by the On Current event of the form.