One More Calendar Control Question

[Chuck]

Seems as if there are many questions about the ActiveX calendar control and
many warnings on not to use them. I have used them with some success, but
some issues just make me scratch my head. I am currently using it to have
the user select a start date and an end date to run a report. The form
opens and the calendars are set to the current date. If the user clicks
anywhere on the dates, the start or end date changes accordingly. The
problem I have is when the user selects a different month or year, none of
the dates are depressed. The user has to select a new date within the
selected month. However, if the user just changes the month and runs the
report, the calendar value is still the previously selected month and date.
I would like to set an event that if the user changes the month or year and
attempts to run the report, for a message to appear indicating that a date
must be selected. It appears that none of the events trigger when the month
or year is changed but only when the user clicks within the actual month
view. Any ideas? Thanks.

 

[Linq Adams via AccessMonster.com]

So you're saying that your users have to have a messagebox to tell them that
they have to PICK A DATE in order for A DATE TO BE PICKED? This concept is
too much for them to handle without prompting?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

 

[Linq Adams via AccessMonster.com]

Actually there are events that trigger when the month or year is changed;
NewMonth and NewYear. This code will pop a reminder when either is changed:

Private Sub YourCalendarName_NewMonth()
MsgBox "You Must Pick a Date"
End Sub

Private Sub YourCalendarName_NewYear()
MsgBox "You Must Pick a Date"
End Sub