Calandar controls and format

[kp1279]

Hi

I have an SQL 2000 database, with an ADP (Access 2000) front end.

I have a table as an events calandar, with the columns:

Event_ID as int
Date_Of_Event as smalldatetime
Event_Description as varchar(1000)
Person_responsible as varchar(4)

I have created a form with the calandar controls on for which i have set the control to be the date_of_event, and text boxes on for the other two.

I can enter any event fine, and can scroll through the events using the navigation buttons, but....

Is there any way I can either create a new form or alter the existing for so that the calandar shows all the events on the days they are, so that the user can then clisk on the day for the full info????

Hopefully this makes sence to someone, and help is apreciated.

....

 

[ProgramError]

try this link

http://www.referee-assistant.com/calcontrol.htm

Ian Mayor (UK)
Program Error
Programming is 1% coding, 50% error checking and 49% sweat as your application bombs out in front of the client.

 

[kp1279]

Exactly what I am looking for. Many thanks.

I would like to be able to havve the ability to have more than one entry per day, but I think I will be able to sort that from what you have given.

....