i have been guided by mr b to this point. he has pointed out that a listview might be able to solve my query.
the query is, i have a diary(again curtacy of mr b) that displays the days appointments. each appointment has a status(not displayed in the diary view) of 1=default 2=client has arrived and 3=client has paid for the treatments. the view i have at the minute is from a list box. the 1st cloumn is the time intervals from 9am until 8pm every 15mins. the 2nd column is the client that has booked the appointment and the 3rd is the appointment end time.
what i really want is to 'block out' the appointment duration in a designated colour. i would like to be able to have 4 different colours. one for each of the status' and one for if the appointment time has elapsed and the client has not shown then i think blocking this out in red would be appropriate.
i have search the internet about list view but i am a little daunted by what i read. im wondering if anyone could push me in the right direction of the end result i want to achieve. i have uploaded my database in full (minus personal details) for you to browse. the main diary is frmDiaryView.
thanks for any help regarding this
the query is, i have a diary(again curtacy of mr b) that displays the days appointments. each appointment has a status(not displayed in the diary view) of 1=default 2=client has arrived and 3=client has paid for the treatments. the view i have at the minute is from a list box. the 1st cloumn is the time intervals from 9am until 8pm every 15mins. the 2nd column is the client that has booked the appointment and the 3rd is the appointment end time.
what i really want is to 'block out' the appointment duration in a designated colour. i would like to be able to have 4 different colours. one for each of the status' and one for if the appointment time has elapsed and the client has not shown then i think blocking this out in red would be appropriate.
i have search the internet about list view but i am a little daunted by what i read. im wondering if anyone could push me in the right direction of the end result i want to achieve. i have uploaded my database in full (minus personal details) for you to browse. the main diary is frmDiaryView.
thanks for any help regarding this