B
Brad McCulloch
Hi All.
I'm writing a scheduling tool in Access 97 (it's the
version i have) and i want to create a "calendar" that has
notes for days where activities are required. I'm
currently about to use:
1. Date generating query to create the linear list of all
dates (within a range)
2. A function to return as a string all the events due on
each date
3. A left join query to join the two
4. A crosstab to group into days of the week and week
numbers
5 A flexigrid control to display all this.
6. Some combo boxes to control the year and month that is
displayed.
There's gotta be a better way. Is anyone aware of one?
Like a Calendar control that you can assign notes to dates
in?
Regards and advthanksance.
B
I'm writing a scheduling tool in Access 97 (it's the
version i have) and i want to create a "calendar" that has
notes for days where activities are required. I'm
currently about to use:
1. Date generating query to create the linear list of all
dates (within a range)
2. A function to return as a string all the events due on
each date
3. A left join query to join the two
4. A crosstab to group into days of the week and week
numbers
5 A flexigrid control to display all this.
6. Some combo boxes to control the year and month that is
displayed.
There's gotta be a better way. Is anyone aware of one?
Like a Calendar control that you can assign notes to dates
in?
Regards and advthanksance.
B