Calendar Form

[wort0987654321]

calender form

i want to be able to create a form where i can select a month of the year from a combo box and the dates and days will be shown for that month. i also want to be able to display any rentals that are due back to the company for each day.

is there any way of doing this

any help would be much appriciated

thank you

 

[Mile-O]

Do a search on Calendar as I've posted loads of different examples using the Calendar Control.

As for you second part then this is easily done by requerying if you select a date in the Calendar Control.

 

[wort0987654321]

i have got the calender to appear on my form but im noy sure how to get the rentals that are due back on the dates to appear.

please can you make any instructions easy to understand as i get confused easily

 

[wort0987654321]

also is ther any way that i can make the calender allow data entry so that the company can enter important information

 

[Mile-O]

i have got the calender to appear on my form but im noy sure how to get the rentals that are due back on the dates to appear.

You'll need a query.

Put a listbox on your form. Build a query for the results you want. Set this query as the listbox's RowSource.

Set the Calendar's AfterUpdate event to requery the listbox.

Ensure the query (on a date field) has the criteria that references the calendar.