Aaron,
>
> By reference to each shape's tag information, the date and time
> were calculated, then an editbox is added programmatically on the
> form, however, the problem is When TWO or more appointment occupied
> the same time slot e.g.
>
> Appointment A: 9:30-10:30
> Appointment B: 10:00-10:30
>
> The editbox of Appointment B will be completely covered by Appointment
> A. My thought is that: if there is a double booking, the editbox of
> Appointment B move to right for 5 pixels, so that the right border is
> visible to user, but I can't think of anyway to detect.
>
Best thing would be to prevent overlapping appointments from being created. But if You need to allow them, I would not check for overlapping objects but "Times" in the database.
As I guess the position of the object does show the time, I would not move them to the right or left but make them higher or flatter and by playing with the zOrder stack them so that each appointment can be seen and selected.
by the way. We do have a Personnel-planning system. If You like, have a look at
http://www.personalplanung.comHTH