Recent content by stefanocps

here is the updated version. As Peter told me, the file was first published in the Utter Access forum. Enjoy! I still need some help with it for the time slot management, hope Peter can do otherwise i'll ask you again!:)

he send to me via mail,so i have asked him if i can post it...you know is better to have his permission before, and i'll be happy to post it here!

Hi, impotant update Don't work at this file as the author, Peter, send me a new version of the calendar, which really looks gorgeous, so if we have to edit the db, is better to edit the new one Waiting to see what it is needed to edit If you like i might ask Peter if i can post it

if you want to do more edit please use mine. In this there is acorrection for an erorr in listing the field name, plus i have added another room

yes great 2 more thing the first is an error in the appontments scheduler when try to change the start date or end date through the popup The second is that i would lik eto chenge the hours slot som room have 1 hour slot so 8:00-9:00 9:00-10:00 and so on other rooms has different like 8:40-9:20...

i have also found another error, but this is from the original db Still in that form frmCalendarAppt, when i create a new appt, if i try to change the end date of the appt i get error, and i need to close the db

yes and it works fine but in the frmCalendarAppt. When i double click on a daily view day to insert a schedule, that form open showing all the schedule for that day. It shows not only the room i am working at but the other room schedule also

yes i have no problem with it, but with the frmcalendarappt showing all the room appointments instead of the selected one only!

yes, i do that. So i want thatht in the frm.calendarAppt also the listed data are filtered byt the room color. Is that possible? i have found this code SELECT tblAppointments.ApptID, Format([ApptStart],"Short Date") & " " & Format([ApptStart],"Short Time") AS AD, Format([ApptEnd],"Short Date")...

ok have found the syntax error, there was a . instead of , ,when listing the field of the form

ok testing and i have found an error. If i insert data in the daily view, without opening the appointmente windows i get error, syntax error in instruction INSERT TO, trying to check the code but can't understand the error yet. Also..(but for this i need to talk with my colleagues) when i open...

is this the one you want to send me? i don see the new field in the table and the form you have added seems to do not work don't open anything and there is no code associated on clic action

here already i am trying to do the way i think to it at the beginning Thewre is a field APPTLOCATion in tblappointments whivh i thought i could use it. Can i use it right?don't need to create a new field Now i have added the unbound text in the main form, an dat this point i get lost. How...

thtis is what i thought at the beginning but it seemed too complicated...anyway i'll try now that i have some hint on where to start. if i need i might come back later for further requests thanks for now

ok so i have not explained well then We have 3 to 5 different areas with different scheduler for example appointment in blue room, appointments in red room etc... So we need different scheduler for blue room, red room etc I could use one instance of the file ofr the red room, another one for...