how to change the time interval for Resource Scheduling database

[Justiceankamah]

Manipulate Access Database Example for Reservations
I am using the Resource Scheduling Database Sample from
http://office.microsoft.com/en-us/templates/

I am having issues with the Dates and the schedule. I don't understand how
it knows that 8am is 8:00 etc. I tried to change it to 5 minute increments
and
did the following

dbl5Minutes = TimeSerial(8, 5, 0) - TimeSerial(8, 0, 0)
dblBeginTime = Me![BeginTime].ListIndex * dbl5Minutes
dblEndTime = Me![EndTime].ListIndex * dbl5Minutes
dblTimeIncr = dbl5Minutes * Me![TimeIncrement].Column(0) 'column 0
contains the number of 5 minute time segments in the time increment

But, now the incremening half works. When I choose 20 minutes, It starts
the 8am day at 1:20 and increments it by 20 minutes until 3am. When I choose
45 minutes, it starts the 8am day at 1:20 and increments by 45 minutes until
2:50am.

Please advise on how to make the time increments 5 min, 10 mins, 15 mins, 20
mins, 25 mins, 30 mins and 1 hour

 

[Jack Leach]

Have you tried the DateAdd() function? This may be more suitable for your
situation.

hth
--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)