Calendar Question

[wop0703]

I want a form that has a calendar. When the user clicks a certain date, I want the form to access a field in a table which will have entries that correspond to the date. Then I want all the entries in the table displayed beneath the calendar in the form. Can anyone help?

Thanks

 

[ColinEssex]

You could have the calendar pop the date in a TextBox, then run a query to populate either a SubForm or a ListBox using the selected date as the criteria.

Col

 

[wop0703]

How would I get the calendar to pop the date in the text box?

 

[Mile-O]

Something like this?

 

[ScottGem]

I want a form that has a calendar. When the user clicks a certain date, I want the form to access a field in a table which will have entries that correspond to the date. Then I want all the entries in the table displayed beneath the calendar in the form. Can anyone help?

Thanks

or this attachment

 

[wop0703]

Thank you both for the examples. I am still haveing some trouble with this because the examples seem to involve alot ofcoding in which I am not familiar with, but hopefully I will work it out.

Thanks

 

[Mile-O]

I think my example had a whopping two lines of code that you need to understand (on the Click event of cmdDate) - the form called frmCalendar can be imported into your database, the colours customised, and off you go...

 

[ScottGem]

Same thing for my example. You copy the forms and the module into your app. The 2 test forms can be used as examples. The way mine is setup you can either double click on a text box or click on a button next to the box. the only code you need to change is if you use the button. In that case you need to supply the name of the textbox where you want to store the selected value.