Flag a future date

  • Thread starter Thread starter Mat
  • Start date Start date
M

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.
 
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.
 
Back
Top