Access 2003 popup calendar

[jeffreyswilson]

I have been able to add a nice popup calendar when I click into a data
field on my Access 2003 form. But the date only gets placed into the
field once I move out of the field and into another. I would like it
to populate the field as soon as I click on the date in the calendar.
Can someone tell me what I am doing wrong? Here is my code:

TrainingDateCal.Visible = True
TrainingDateCal.SetFocus
If Not IsNull(Training_Date) Then
Training_Date.Value = TrainingDateCal.Value
Else
TrainingDateCal.Value = Date
End If

Thanks very much in advance!

Jeff Wilson

 

[jeffreyswilson]

Strange...it seems like my problem is when I make the control not
visible. Everything works if I keep the Visible=True, but as soon as I
make the calendar disappear with Visible=False, the date no longer
updates...does this make sense to anyone?? Thanks again....

 

[jeffreyswilson]

Never mind...I got it. I was making the control invisible before the
field was updated. Works great now. Now if I can only figure out how
to use the same calendar object to update all of the date fields on my
form!!

 

[Guest]

Jeff,

I'm having the same problem but haven't solved it yet. My date field only
updates when you click on it and the calendar remains up even though the
property is set to visible=False.

Now access is saying it has to reinstall the activeX control since the
calendar is not functioning properly. What code did you use to solve it?

-Jessel

 

[Allen Browne]

You can avoid the whole problem with ActiveX controls if you just use a
simple little Access form as a pop-up calendar.

Here's one you can download and copy into your database:
http://allenbrowne.com/ser-51.html