Appointment Calendar

[speakers_86]

I found a thread on this site with the attached db. I would like to change the calendar so that when an appointment is double clicked, it opens frmAppointments where the appointment id equals that of the appointment clicked, instead of opening frmDialy. Any suggesstions?

 

[Galaxiom]

Check the code on the DoubleClick event and change the form name.
Set the Where condition argument to something like:
"formcontrolname = appointmentID"
http://msdn.microsoft.com/en-us/library/aa141520(office.10).aspx

(I haven't looked at the database)

 

[speakers_86]

It doesn't appear to be that simple in this case.

 

[speakers_86]

I think I will just change frmDaily so that it fits my needs a little better. Maybe I will make it a continuous form that will show all appointments for that day.

 

[bitsbb01]

Hi Speakers, i have a question as it seems you've been using this database for awhile, and i've been looking for a schedule for a long time.. and just finaly came accross this 1.. and been playing around with it.. however i have 1 question, or maybe it 2..

When you pick the start time, is there a way of having it delete that start time or mark it booked.. so that its only used once per day.. as we only want 1 appointment per time.. I'm using Access 2010.. and so far am loving it.. however have spent almost all day trying to get this to work...