|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 2nd, 2009, 02:19 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Values unbound textbox based on calculation of 3 other fields
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]? 
|
|
#2
June 2nd, 2009, 04:23 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Values unbound textbox based on calculation of 3 other fields
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" wrote: 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]?
|
|
#3
June 2nd, 2009, 07:50 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Values unbound textbox based on calculation of 3 other fields
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" wrote: 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" wrote: 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]?
|
|
#4
June 2nd, 2009, 07:51 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Values unbound textbox based on calculation of 3 other fields
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" wrote: 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" wrote: 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]?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
