Adding "Groups" to an appointment calendar

[DCXtreme]

Hi there,

I have this sports center database. Basically what I have is a appointments or "bookings" form which I want to be able to modify to be able to add / delete groups that want to book time in the sports center, whenever I try to do this though however the bookings fail to show up on frmcalendar_daily.

Anyone got any ideas or suggestions (i deleted the groups table / form, decided to start from scratch!)

Jon

 

[Steve2003]

Your calendar was exactly what I was looking for and I had the same problem as you. I have managed to fix it by changing your code slightly.

in your Displaymeetings I changed

strApptDate = Left(strApptDate, intLen - intPos)
to
strApptDate = Left(strApptDate, 2)

and then in your Displaydailymeetings


"WHERE tblAppointments.ApptDate = #" dteMyDate "# " & _
to

"WHERE tblAppointments.ApptDate = #" & Format(DateValue(dteMyDate), "mm/dd/yy") & "# " & _


I am using access 2003 but I hope this helps

Steve