I suggest that you show a month calendar to pick the date, and a week calendar to select the time. In the week calendar you can show seven columns, one for each day, and one row for each hour.

>I need to have a table of appointment types. The following is an example of what that table could look like. I'm having a hard time coming up with the best way for the user to select the various values though. I would like to use a calendar for the dates. Not sure about the times. I'm also going to use a picklist for the RGB codes (these won't be seen by the user, just the color picker). Just looking for suggestions on how to present this. They will need to be able to see all the rows/records and add/delete/edit. Any suggestions welcome. The simpler the better, but I want it to have a bit of a slick look. I already have a nice color picker to use, and I know I can use the calendar OCX, but how best to give it all to them to select? Thanks!
>
>

>
>APPTTYPE         RED       GREEN        BLUE  STARTDATE STARTTIME     ENDDATE   ENDTIME      DOW
>
>New Patient       0           0         255   12/18/07  09:00:00 AM   12/18/08  12:00:00 PM   2
>New Patient       0           0         255   12/18/07  02:00:00 AM   12/18/08  12:00:00 PM   3
>Follow Up         0         255           0   12/18/07  09:00:00 AM   12/18/08  12:00:00 PM   4
>Nurse Visit      255          0           0   12/18/07  02:00:00 PM   12/18/08  05:00:00 PM   2
>Nurse Visit      255          0           0   12/18/07  02:00:00 PM   12/18/08  05:00:00 PM   4
>Nurse Visit      255          0           0   12/18/07  02:00:00 PM   12/18/08  05:00:00 PM   6
>Surgery           0         255         255   12/18/07  09:00:00 AM   12/18/08  12:00:00 PM   5
>Lab               0           0         255   12/18/07  09:00:00 AM   12/18/08  12:00:00 PM   6
>Annual Physical  255         255          0   12/18/07  09:00:00 AM   12/18/08  12:00:00 PM   7
>
>