[AccessD] A2K: Repeat Appointments

Darren, I have posted a little offline about this, but I was thinking about
this a few minutes ago.  What I proposed a while back (and will incorporate
as a tool for the MiniCalendar) was a bit scheduler.  You can break each day
up into segments, and instead of storing a record for each 'time slot', you
store 1 record with a few long integers representing the chunks of time with
each bit in the integers.

Along those same lines, why not make a bit 'mask' to determine
repetitiveness.  For example, there can only be 5 repeat days in a month.
(5 sundays, 5 mondays, etc.).  You can represent each day of the week as a
bit, which is 7 bits, and to repeat that 5 times, you are looking at 35
bits.  (which is just over 4 bytes.....(a long integer)).  Then, when
viewing the schedule for a particular day, week, or month, instead of having
records of all 'repeats', just pull a query that determines if a record
meets the bitmask.

I know that may be a little hard to understand...but I'll have a demo in the
MiniCalendar....

Drew

>  -----Original Message-----
> From: 	Darren Dick [mailto:d.dick at uws.edu.au] 
> Sent:	Sunday, February 09, 2003 10:46 PM
> To:	AccessD List
> Subject:	[AccessD] A2K: Repeat Appointments
> 
> Hello all
> I am creating a scheduling dB - Not very well though:-( 
> I have 2 Questions (actually many more but we'll start with 2 <vbg>)
> 
> 1)	Can some one point me in the direction about how to create repeat
> 	appointment code. EG make the booking below, in Q2, occcur each
> Monday 'til June 30 2003??
> 
> 2)	If a booking is made on Jan 6th 2003 from 1pm to 3pm by John Smith
> 	how would I get it to display across 3 time slots or something like
> it.
> 
> I am envisioning each of the days mon Tues etc will be a single subform
> within the db
> but placed on the Parent form 7 times - each with a slightly different
> recordsource.
> 
> EG. Form layout will be 
> 
> 		MON		TUES 		WED 		THU
> FRI etc
> 09:00am
> 10:00am
> 11:00am
> 12:00pm
> 13:00pm    John Smith
> 14:00pm    John Smith
> 15:00pm    John Smith
> 16:00pm
> 17:00pm
> 09:00pm
> 
> 
> Many many thanks in advance
> 
> Darren
>