Calendar Control Help

[marcus]

What I have been trying to do is create a simple form that
people enter in vacation days that simply has fields
staff; date; type(with dropdowns vac,sick,loa,etc) and
duration.

What I would like to do is create a calendar that people
can pick a date and view and or enter their requests, and
I would like to flag all the new entries to pull into a
report for boss to approve.

I have been able to get the calendar into the form, but
just can't seem to make it link to the table.

I would so appreciate any suggestions/help.

Thanks in advance

marc

 

[MikeB]

I learned how to use the Calendar Control from a book sold by MS Press. It is entitled, "Running Microsoft Access 2000", by John Viescas. See Ch. 23. I have since modified the approach presented, but that may be a good start. On the down side, it requires a bit of code because you manage three separate controls: text box, toggle, and calendar for each date field. My changes allow me to reuse the same calendar control for each date field. I relocate and resize the calendar control to fit in the form and align with the text box and toggle. The toggle is used to display and hide the calendar control. The text box is bound to the table. You can also experiment with the control, DatePicker.