check date() against field "due date"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stella P - 07 Dec 2005 22:47 GMT

L.S.

I have a form with 2 subforms.
On subform2 there is a field which has as default date().
On subform1 there is a field with the "due date" of the product.

The "default date", which is todays date when opening the form, has to be
checked against the "due date".
If "default date" > than "due date" the field "due date" has to change of
background color and blink and a message box has to appear saying that
"Default date is > than due date".

How can I have "default date" (date() ) check against "due date"?
I have the coding in the beforeupdate event in the field "default date", but
it only works if I enter the "default date" manually.
And how can I have the cursor on the field "default date" if this field >
than "due date".
I've tried using SetFocus but I keep on getting an error.

Thanks in advance for your help.

Stella

Reply to this Message

Alp Bekisoglu - 07 Dec 2005 22:59 GMT

Have you checked Conditional Formatting? You can set the background color of
the field to red if the field value is less than Now(). But Access2000 does
not provide an option for blinking there. You would need to code that part.

For the message part, you can also code it.

Hope it helps a little.

Alp

> L.S.
>
[quoted text clipped - 19 lines]
>
> Stella

Reply to this Message

Stella Pieters - 09 Dec 2005 11:28 GMT

Hi Alp,

Thanks for the solution.
I have this other part which I cannot solve.

How can I have "default date" (which has as default date() checked against
"due date"?
I have the coding in the beforeupdate event in the field "default date", but
it only works if I enter the "default date" manually.
And how can I have the cursor focused on the field "default date" if this
field >
than "due date".
I've tried using SetFocus but I keep on getting an error.

>Have you checked Conditional Formatting? You can set the background color of
>the field to red if the field value is less than Now(). But Access2000 does
[quoted text clipped - 11 lines]
>>
>> Stella

Reply to this Message