Calendar ActiveX Control Date Value Issues

[Marco]

I have Access 2003 and have inserted an Calendar 11.0 ActiveX control. I
have had no success setting the default value to today's date. I have tried
Me.Calendar6.Value = Date in both the On Current and On Load events and it
doesn't seem to work. For some reason, the Date keeps on going to the date I
created the activex control, Nov 27 2004. Why does this control think that
today's date is still the 27th of November? Doesn't it use the computers
clock for current date? Thanks for your assistance.

 

[Allen Browne]

Hi Marco

The calendar control is messy, has problems with nulls, is subject to
reference problems, and breaks the application when you upgrade/change
versions.

Would you be happy with a simple little pop-up form you can import into your
app to select a date? Copy from:
http://members.iinet.net.au/~allenbrowne/ser-51.html

 

[Marco]

I can use that calendar in place of the active x, but not sure it will work
as well. We are now entering our time using Access 2003 and I have written a
form that captures this information. Currently when they access the frmTime
form, there is the ActiveX calendar at top and in the form detail is all of
the time entries associated with the date selected on the calendar control,
txtCalendar. Changing the date on the calendar updates the form with the
users time entries for that day.

Everything works fine with the exception of the calendars default value on
opening. How could I incorporate your calendar form in this scenario? Thanks!

 

[Marco]

Allen,

Thanks for your help! I was able to get it working using your calendar
form. Have agreat day, and thanks again!

Marco