Dependent date field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I am trying to build an Access database that has a table with skill
assessments in it. I have a skill, a skill level, an assessment date and a
reassessment date. I want to make the reassessment date automatically appear
as 6 months or 1 year after the assessment date. Does anyone have any ideas
about how I can do this?
Thanks,
Mark
 
What you need is code that checks the reassessment date and a date + 1
year. In the OnCurrent of the form insert this code:

If Me!txtDate = DateAdd( "yyyy", 1, Me!txtDate) Then
Me!txtDate.Visible = True
Else
Me!txtDate.Visible = False
End If

Replace the txtDate with your control name.
 
mal1920 said:
Hi, I am trying to build an Access database that has a table with skill
assessments in it. I have a skill, a skill level, an assessment date and a
reassessment date. I want to make the reassessment date automatically appear
as 6 months or 1 year after the assessment date. Does anyone have any ideas
about how I can do this?
Thanks,
Mark
Click to expand...
Look at DateAdd.

Ron
 
ReassessmentDate:[AssessmentDate]+60 placed in a query to give you the new
Assessment Date. You can also create a textbox field where this calculation
can be created. The difference is that you don't have to specify a qualifer
field name prior. Just type in the textbox Control Source area under
Properties: =[AssessmentDate] + 60.
 
Back
Top