stillnew2vb
Registered User.
- Local time
- Today, 08:34
- Joined
- Sep 20, 2010
- Messages
- 34
Greetings Gurus,
Please could someone tell me how to add 2 time values together?
I have a form which has two unbound text boxes into which a user can submit a numeric value (e.g. "10") which is supposed to be the amount of time that user has been doing something. This value is supposed to be added to a date/time field on the same form but it just isn't happening..
My current "after-update" code
The code doesn't error anywhere but the dtDuration field doesn't change, dtMinute & dtHour are being regarded as 0.
Please could someone tell me how to add 2 time values together?
I have a form which has two unbound text boxes into which a user can submit a numeric value (e.g. "10") which is supposed to be the amount of time that user has been doing something. This value is supposed to be added to a date/time field on the same form but it just isn't happening..
My current "after-update" code
Code:
Dim dtDuration As Date
Dim dtMinute As Date
Dim dtHour As Date
dtDuration = Me.Duration
dtMinute = Me.AddMins
dtHour = Me.AddHours
Me.Duration = Me.Duration.OldValue + dtMinute