Creating a calendar on a form.

[rplohocky]

Hello,
I have been struggling to find anything on creating a calendar on a basic form where you can click on the day and schedule an appointment. I would like to have the user be able to view the month, choose a day, double click the day they want, a form opens for additional info relating to the appointment and most important only have 2 appointments available for each day. Does anyone have a bear bones database that would do something like this?

My other option is to make a form that looks like a calendar using the rectangle tool for each day then text boxes for each number of the day then insert 2 text boxes in each day box so the user can see that there are open slots or not. This is not my first choice because it will take many hours for each month and its not re-portable.

Thanks for any help!

 

[RedBeard]

Key word being database.
Don't do this in Excel.

 

[mrmmickle1]

Try this calendar: http://www.ozgrid.com/forum/showthread.php?t=205247

 

[Micron]

check here, post number 2 there is an attachment
http://www.accessforums.net/showthread.php?t=60470

 

[rplohocky]

check here, post number 2 there is an attachment
http://www.accessforums.net/showthread.php?t=60470

Thank you all for replying.

Micron, The calendar you sent me to was the best by far and for the most part exactly what I was looking for. Thanks to Peter Hibbs, that must have taken numerous hours to build. I'm glad there are people like you out there to help people like me. Thanks again Micron to leading me to this calendar. The internet is so big I would have never found it.

 

[Micron]

You're welcome. Glad to have helped.