MsgBox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wilfried - 08 Oct 2006 21:13 GMT

How can I create a MsgBox when a date, in a Field, is beyond 30 days

Reply to this Message

Doug Robbins - Word MVP - 08 Oct 2006 21:42 GMT

Use the DateDiff () function in an If...Then...End If construction.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> How can I create a MsgBox when a date, in a Field, is beyond 30 days

Reply to this Message

wilfried - 08 Oct 2006 22:34 GMT

I thank You already for your answer. Is it possible to give me more
details. I am a beginner and it is for private use. I do not know very
much about If...Then...End If construction.

Is it possible that in that message the text is: "You have to send a
letter to XXX" XXX refers to the record where the date given in a field
is beyond 30 days.

If needed I will pay for the the answer. Send a personal e-mail if you
like it.

Doug Robbins - Word MVP schreef:

> Use the DateDiff () function in an If...Then...End If construction.
>
[quoted text clipped - 7 lines]
>
> > How can I create a MsgBox when a date, in a Field, is beyond 30 days

Reply to this Message