Adding 10 min to a stored time

[213emi]

This is a little more frustrating than i thought it would be.
What i'm trying to do is just add an arbitrary 10 min to an already existing time.

The scenario: Scheduling
A student is partaking in various activities throught the day
They can do multiple events in one day but a 10 min must be added on the end of each event to account for the 'walking' time to the next event.
Each activity is 15 min long.
Another student may start the activity while the first student is in the walking time so i can't just make the activity times 25 min.

I have tried just adding the 10 min all sorts of ways but nothing works.
Is there some special format i need to put the 10 min in so its the same as the time i'm adding it to?

I am taking my first database class so i only have a basic understanding of access and vba. Anything will help though.
Ty for your time

 

[SydneyGeek]

I usually use the Time function to add distinct intervals.
For example, Time(0,10,0) is 10 minutes; Time(10,0,0) is 10 hours; Time(0,0,10) is 10 seconds.

Denis

 

[less500]

Ever try macking a vba macro.

 

[revans]

Look up DateAdd.

DateAdd("n",10,Now())

Instead of Now() you would substitute your time value.

hth,

Rich

 

[213emi]

ty guys
a friend told me of the dateadd() function today in class

 

[213emi]

Now i'm having some trouble with the actual update
It has like a delay. Whenever i update it it changes to the one i had before
and it won't change to the new one until i update it again

Private Sub ComboHour_Change()
'----------------------- update the 10 min and 15 min textboxes -------------------
If IsNull(TimeBox) Then
Else
Me.Text10min.Value = DateAdd("n", -10, TimeBox)
Me.Text15min.Value = DateAdd("n", 15, TimeBox)
End If
Me.TimeBox.Value = DLookup("[TimeQ]", "Query_Time_Reserve")
Me.Refresh
End Sub

 

[revans]

Try the afterupdate event. The change event fires after each keypress (I believe) and is strange.

hth,

Rich