form based calendar/scheduler

[jonnydexter]

i am looking to code up a form which will display a 'clickable' calendar for a chosen month/year.
my prolem is, the best way to get the correct dates to show under the correct days. At present i have 5 row of seven columns with an (additional) heading on each column fot the day of the week ( starting on sunday). i can calculate the days in the month, the first day of the month etc using dateserial, but what is the best method to address the textboxs. Should i be looking at an array , a collection or something else ?
i want to be able to calculate the offset for the first day of the month and then just populate along the textboxs based on the total days per month, which is why i was considering creating a collection of the textboxs.
Any ideas or suggestions would be greatly appreciated.

 

[speakers_86]

This is quite difficult. Your best bet is to use CyberCow's example.

 

[jonnydexter]

thanks for the links - they look as though i can use them as is but i will take alook a the code ( if possible) and maybe redo it to suit my needs

 

[speakers_86]

Good, thats what I did. Let me know if you need help.

 

[cyb3rwolf]

Unless i'm misuderstanding what you're trying to do, you can insert a Calendar ActiveX Control.

 

[speakers_86]

The activex control is merely a date selector. It does not really help for creating an appointment calendar.