[AccessD] A2K: Repeat Appointments

Darren Dick d.dick at uws.edu.au
Sun Feb 9 22:47:00 CST 2003


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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 1932 bytes
Desc: not available
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030209/1c6b145e/attachment-0001.bin>


More information about the AccessD mailing list