I'm trying to get access to project future dates from the date i initially enter. For example, If I entered 6 Jan 2002, I would want one field to project out 3 months, another 6 months, and the third one year.
Hi Sentra52,
Using Access 2000:
In the after update event of the date your are entering, set the other date fields using the DateAdd function.
Example:
Private Sub Action_Date_AfterUpdate()
newdate= DateAdd("m", 3, Action_Date)
End Sub
The above example sets date field newdate to value of Action_Date plus 3 months.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.