6 Mth. Review is exactly 6 Mths. + 1 day from the yearly Recert. Is there a way to do a Formula in Access 2003 to make 6 Mth Review field auto-fill once the Yearly Recert. field info. is entered?
Example: Recert. = July 31, 2010; 6 Mth. Review would = Feb. 1, 2011.
I like to try to keep things as simple as possible. Here’s how I would do it, fwiw.
Let’s say the name of your field for recert is txtRecert (doesn’t matter what you name it)
On your form, create an unbound text field. That will be your "review would" field. Let’s say you name that field txtReview (doesn’t matter what you name it). Select properties for txtReview. In the control source I would put =[txtRecert]+180. In the format box for txtReview make sure the format is set to the date format you like (ex: mmm dd yyyy would give a date of Oct 25 2009) The 180 is 6months (30days x 6). As soon as you input a date into the txtRecert box, it will automatically fill txtReview with 6months out date.
October 31st, 2009 at 10:33 pm
Dateadd() with a + 6 month add (in VBA triggered by whatever the user uses to fill in the recert date).
References :
October 31st, 2009 at 11:15 pm
I like to try to keep things as simple as possible. Here’s how I would do it, fwiw.
Let’s say the name of your field for recert is txtRecert (doesn’t matter what you name it)
On your form, create an unbound text field. That will be your "review would" field. Let’s say you name that field txtReview (doesn’t matter what you name it). Select properties for txtReview. In the control source I would put =[txtRecert]+180. In the format box for txtReview make sure the format is set to the date format you like (ex: mmm dd yyyy would give a date of Oct 25 2009) The 180 is 6months (30days x 6). As soon as you input a date into the txtRecert box, it will automatically fill txtReview with 6months out date.
References :