shieldsco
asked on
Increment Access Date Field
I want to increment an access form date field every 90 days based on another date field -- the starting point. Another exchange expert wrote the code below however when I add a new record the form is in an endless loop and locks the database. I'm looking for a solution to the loop problem. I have attached the databses - from the main menu select Add/Chng Veterans ALL to access the form VASH1.
Private Sub Form_Current()
Me.TreatmentDate = DateAdd("d", 90, Me.AdmitDate)
Do
Me.TreatmentDate = DateAdd("d", 90, Me.TreatmentDate)
Loop Until Date <= Me.TreatmentDate
End Sub
Private Sub Form_Load()
If Not IsNull(Me.TreatmentDate) Then
If Date > Me.TreatmentDate Then
Me.TreatmentDate = DateAdd("d", 90, Me.TreatmentDate)
End If
Else
'MsgBox "TreatMent Date is " & Nz(Me.TreatmentDate, #1/1/1900#)
Me.TreatmentDate = DateAdd("d", 90, Me.AdmitDate)
Do
Me.TreatmentDate = DateAdd("d", 90, Me.TreatmentDate)
Loop Until Date <= Me.TreatmentDate
End If
End Sub
VASH-V1-4.accdb
Private Sub Form_Current()
Me.TreatmentDate = DateAdd("d", 90, Me.AdmitDate)
Do
Me.TreatmentDate = DateAdd("d", 90, Me.TreatmentDate)
Loop Until Date <= Me.TreatmentDate
End Sub
Private Sub Form_Load()
If Not IsNull(Me.TreatmentDate) Then
If Date > Me.TreatmentDate Then
Me.TreatmentDate = DateAdd("d", 90, Me.TreatmentDate)
End If
Else
'MsgBox "TreatMent Date is " & Nz(Me.TreatmentDate, #1/1/1900#)
Me.TreatmentDate = DateAdd("d", 90, Me.AdmitDate)
Do
Me.TreatmentDate = DateAdd("d", 90, Me.TreatmentDate)
Loop Until Date <= Me.TreatmentDate
End If
End Sub
VASH-V1-4.accdb
ASKER
After further review I also noticed that once I move from the current record the treatmentdate field data is incorrect - it appears that it is adding 180 days to the date instead of 90 days
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Good job
You are welcome!
/gustav
/gustav
https://www.experts-exchange.com/questions/27513008/Increment-date-field.html?anchorAnswerId=37352324#a37352324