appointment scheduling

[cdacey]

I am trying to add an appointment scheduling feature to my access application, where I can draw off my contacts table to book appointments. I am trying to develop the base table to allow for appt types, calander days, slots, etc... and it seems pretty involved once you get into it. Does anyone know of a good application that integrates well with access and that I could link & boot up from my access application ?? Or another way to accomplich this ??

Thanks Chris

 

[crucial_gear]

Don't know of any appointment application that you could use to hook into Access and pull your contacts from. Honestly the best approach would be to develop the appointment tracking within your contacts database. There are certainly enough people who post on this discussion forum that I would assume would be willing to help you get started with this, myself included.

In addition there are quite a few books on Access that can help get you started as well.

 

[John.Woody]

Access Vesrion 1 had a personal information manager as a sample db. If you send me your email address I'll send it to you. I need a bit of time to dig it out though.

John

 

[cdacey]

Thanks Guys,
My e-mail is cdacey@ripcpc.com.
I have actually been able to develop it to the point where I can book the appointment with all the revelent data (date, time, appt type, reason,etc..) and display that patient's appointments on their info screen, but my real problem is displaying all of todays appointments, including empty appointment slots and moving from day to day. Anyway, maybe if I could see the sample you mentioned it would give me an idea
Thanks Again !
Chris

 

[cdacey]

Hi Everyone, Thanks for the feedback. I have the system working up to this point:

I have created a form that allows me to schedule the patients appointment. On that same form, I have a calander control for the user to select a date. I also have a subform that pulls from a query of existing appointments. I want this subform to only show me those records (i.e. daily appointments) where the date field in the query is equal to the date selected by the user in the calender control. Is this possible ??
Thanks
Chris

 

[cdacey]

I now have this to the point where I can click on the Calander control to change the date field on the form, which I have listed as the control source for the calander control. But the "date" field on the form will not change until I actually move my mouse to click on the date field, and then the value changes to what I clicked on the calender control? Any thoughts ?
Thanks

 

[crucial_gear]

Try doing a requery on the form that has the date.

me.formname.requery

 

[HEMESH00]

Hi Cdacey, Ive Been Looking For Someone Who Is Trying To Do Exactly What Im Trying, Was About To Give Up Hope Then I Read Your Query.

I Too Am Trying To Create A Clients Scheduling System, In The Exact Way As You Are. I Know This I Very Cheeky But I Was Wondering If You Could Let Me See How You Went About Doin It.

Regards
Hemesh

 

[JACKSON]

I did get it to work pretty well. The easiest way would be if I e-mail you the forms and queries. Just send me your email and I will forward you something to look at

Thanks