Values unbound textbox based on calculation of 3 other fields

  • Thread starter Thread starter Pluggie
  • Start date Start date
P

Pluggie

Five fields on my continuous form:
-ID
-Date_Today (date)
-End_Date_Contract (date)
-Duration_Update_Process (numeric)
-Warning (text)

Calculation that determines value of [Warning]:

-If number of days between [End_Date_Contract] and [Date_Today] is equal to
or smaller than [Duration_Update_Proces], display textvalue: "Almost too
late";
-If number of days between the above fields is bigger, display textvalue: ""
-If number of days between the above fields is negative, display textvalue:
"Oh no! Too late!!!"

How do I get this to work in [Warning]?
 
I would suggest you use the form Before Update event to test the values and a
message box to display the messages.
 
Thanks for the intent, but I need the messages to appear as part of the
continuous form, so in an unbound textbox. The application will be webbased
and later on, I want certain messages that are displayed to trigger
auto-emails.
So, any other suggestions?

Klatuu said:
I would suggest you use the form Before Update event to test the values and a
message box to display the messages.
--
Dave Hargis, Microsoft Access MVP


Pluggie said:
Five fields on my continuous form:
-ID
-Date_Today (date)
-End_Date_Contract (date)
-Duration_Update_Process (numeric)
-Warning (text)

Calculation that determines value of [Warning]:

-If number of days between [End_Date_Contract] and [Date_Today] is equal to
or smaller than [Duration_Update_Proces], display textvalue: "Almost too
late";
-If number of days between the above fields is bigger, display textvalue: ""
-If number of days between the above fields is negative, display textvalue:
"Oh no! Too late!!!"

How do I get this to work in [Warning]?
Click to expand...
Click to expand...
 
Thanks for the intent, but I need the messages to appear as part of the
continuous form, so in an unbound textbox. The application will be webbased
and later on, I want certain messages that are displayed to trigger
auto-emails.
So, any other suggestions?

Klatuu said:
I would suggest you use the form Before Update event to test the values and a
message box to display the messages.
--
Dave Hargis, Microsoft Access MVP


Pluggie said:
Five fields on my continuous form:
-ID
-Date_Today (date)
-End_Date_Contract (date)
-Duration_Update_Process (numeric)
-Warning (text)

Calculation that determines value of [Warning]:

-If number of days between [End_Date_Contract] and [Date_Today] is equal to
or smaller than [Duration_Update_Proces], display textvalue: "Almost too
late";
-If number of days between the above fields is bigger, display textvalue: ""
-If number of days between the above fields is negative, display textvalue:
"Oh no! Too late!!!"

How do I get this to work in [Warning]?
Click to expand...
Click to expand...
 
Back
Top