Calendar Button to view calendar

[Guest]

I have a form and want to enter two dates by:
1. Clicking on a button to view the calendar
2. Clicking on the day to post in the field.
3. Posting that date in the field and then hiding the calendar.

Could someone please tell me how to do this? I know how to put the calendar
in the form, and how to tie the population of the field to the calendar, just
not how to create the button to make the calendar visible.

Thanks!

 

[Allen Browne]

You can use the events of the control to assign the value from the calendar
to your date/time field.

We are not clear which calendar you use. The ActiveX control that comes with
Access has version reference problems, and some (like the MS date picker)
have problems with Null. Many people have given up on them and written their
own.

Here's a very simple little Access form that looks and behaves like a popup
calendar:
http://allenbrowne.com/ser-51.html
You just copy the form into your database. No external references. No
versioning problems. And if you want something more, the article also has a
link to Stephen Lebans' little wrapper for the MS Month Calendar Common
Control which looks great and works well, but does require an extra
reference.