Calendar function in MS access

[Dalia Allencher]

I got the attached database somewhere online. I do not own it. It has a great example of Calendar function which I am trying to develop. Could anyone please help me to understand the relation between tblInput and frmCalender (and other forms and reports related to it)so that I can link a table similar to tblcalendar to the calendar function.

I appreciate your response.

[johny10151981]

look at Private Sub Form_Load() at Form_frmCalende r

it calls the function Cal which is defined in modCalender module.

in Cal function is called PutInData. in this function you will get the relationship ......

[Dalia Allencher]

Thank you Johny. I went ahead and changed all the connections of frmCalender to the table tblInput and connected frmCalender to tblcalendar. I changed in the code module and control source of properties by replacing tblInput by tblcalendar and the fields InputText by Steps and InputDate by DueDate as per the fields of tblcalendar.

But, I am getting an error in frmCalender whenever I go to December 2010, October 2010, etc, which have text to show in frmCalender according to tblcalendar. Could you please help? I'have attached the file.

I appreciate your response.

[Dalia Allencher]

I fixed it; thank you. It was a small issue in the code that kept throwing the error.

[johny10151981]

To Fahad,
You better ask it in a different thread

as well as, Debug your code......... you will know why unexpected value is being showed