Could someone help please im in a hole here i would like to use a calendar in one of my apps but dont know how to .

i have a sql table with the colums date, name ,CC_CODE,CH_CODE i would like this calendar to show up(green or red) on itself when the date is populated and then when you click on the date it pops up a little msgbox with the info on that date i.e name cc and ch

i have made an ado comand with a sql expression pulling the info from the table(select date,name,cc_code,ch,code from rca_blah_blah order by date) but that didnt do anything also made an adoc and linked it through the propertiesneither did anything so please help even if its to tell me to go to a site that will help

many thanks

Matthew Allee

Use Microsoft Calendar control.Retrieve the date and if that date is in database display those informations in msgbox.

hi Jef Maria thanks for your help.
already cracked that bit, but im really am having trouble on showing on the calendar when there is some data against that date and stoping them clicking on a date that dosent have any data in.

thank you again if you can help with this very much appreciated.

regards
matthew

When data not there for that date dont display msgbox in that case .or If u want to get only those date with data then use a combo with the values u have for dates in database.