I have a table with daily entries for employees. I want to display a 12-month calendar and highlight each day that contains an entry in the table.
I considered 365 textboxes which is just wrong.
I considered 12 subforms. I'm not sure about child forms.
I considered inserted an Excel object but don't see that as an option.
With the weekday(txtStartDate), I know what day of the week to build my calendar. I would like to dynamically build the table. Can I create labels/textboxes on the fly while reading thru my query?
How would you go about doing this?
I considered 365 textboxes which is just wrong.
I considered 12 subforms. I'm not sure about child forms.
I considered inserted an Excel object but don't see that as an option.
With the weekday(txtStartDate), I know what day of the week to build my calendar. I would like to dynamically build the table. Can I create labels/textboxes on the fly while reading thru my query?
How would you go about doing this?