Appointment Scheduler

[CJ UK]

Hi people.

I'm totally new to this forum and quite new to Access. I'm learning as I go and finding a great deal of help in these forums.I have made a contact management-type database, including a search form to find specific records.

The next step in my database is to create an appointment scheduler. I haven't got a clue where to begin! There are 10 people who an appointment could be booked with, over 5 days per week (Mon-Fri) in 30 minute intervals. I have created a table containing dates up to 2010 and a table containing the appointment times in 30 minute intervals from 0900 to 1900. I also have a table contianing staff who may conduct the appointments.

Unfortunately, I haven't got a clue what to do with them now!

Any input would be greatly appreciated and even better if anyone knows of any examples that may help me.

Thank you.

 

[CJ UK]

Hey, I'm replying to my own question. I've had some thoughts about the design for this problem. We never work with people for any more than a year, therefore the diary does only needs to run from the record creation date to plus 1 year. How about having one of these diaries on each persons record, using list boxes to select time, date, advisor and location which is then sent to the diary. Have a second diary for the advisers. When an appointment is booked the information is also sent to advisers diary. If the cell is already populated by another booking, the db couold then return an error message saying "Adviser unavailable".

What do you think about the concept?

Any ideas on implementaton? Let me know what you think.

Thank you. or ?

 

[Rich]

You don't need a table full of dates to be able to create appointments, Access comes with a calendar control that will allow you to select dates.
Early versions of Access came with a PIM example db, it's to big to post here, so post your EMail and I'll send you a copy

 

[CJ UK]

Hi Rich.

Thank you for your reply. I have a copy of the PIM, found on the net. I have been fiddling about with it and learning a lot as I have gone along. However, what it does not do is allow you to book an appointment for someone through their record and have it appear in the diary. Also some way of stopping you from double-booking. Have been trying to seperate diary from address book but encountering lots of errors. I will keep trying though.

 

[CJ UK]

Hi again.

I'm afraid I'm no further along. I will give more detail in the hope that someone will be able to help.

I work in a team of 10 advisers. Each adviser has 5. 6 or 7 appointments per day, at 30 minute or 1 hour intervals.

I have created a database for the clients records and have created a search dialogue to find a specific record.

I want to create an appointment scheduler. I need to be able to book appointments through a clients record and for that appointment to appear in a field in their record, on an individual advisers diary and on a team diary.

I need to make sure that appointments cannot be double booked.

I have read many posts here and downloaded some examples to try to understand how to construct such a system but am severely struggling.

The reason I am trying to create this system is that I work for a Charity who gives advice to disadvantaged groups in society. There have been many problems with the existing paper-based systems. The Charity has had a systems analysis but cannot afford for the custom software to be produced.

I have taken it upon myself to try to do this. Unfortunately, I have come to this point and hit a brick wall.

Any help, advice or examples that anyone can supply would be greatly appreciated.

Cheers, CJ.

 

[Hayley Baxter]

You can download a sample database Here not sure how much help this will be to you but might be worth looking at.

 

[dazcox]

help

I'm doing a similar thing to you guys - anybody have any ideas about preventing double bookings?

 

[A|ex]

hi ive just started something like this and i was wondering where u guys got to? the thing i want to do is something similar to the sample appointment but i would like it looking more like a journal in outlook.

To prevent double booking all you need to do is make sure the time entered doesnt equal any of the times currently or without a 30 min range