ActiveX Calendar events...

  • Thread starter Thread starter Sid
  • Start date Start date
S

Sid

On the Calendar 8 Activex control in Access 97, how can I get an event or
run code when the month or year is selection changed. I wanted to update my
surrounding form's controls according to changes made in Calendar. I now
send Calendar the current month and first day when opening with:
D = Day(Date)
M = Month(Date)
Y = Year(Date)
Me!ActiveXCalendar = DateSerial(Y, M, 1)
I can do it manually with a Button or Lost Focus that uses:
ActiveXCalendat.Value
Thanks
Sid
 
-----Original Message-----
On the Calendar 8 Activex control in Access 97, how can I get an event or
run code when the month or year is selection changed. I wanted to update my
surrounding form's controls according to changes made in Calendar. I now
send Calendar the current month and first day when opening with:
D = Day(Date)
M = Month(Date)
Y = Year(Date)
Me!ActiveXCalendar = DateSerial(Y, M, 1)
I can do it manually with a Button or Lost Focus that uses:
ActiveXCalendat.Value
Thanks
Sid
Click to expand...
Hi Sid, use the calander object click event. for example
control with name atxDate use

private sub atxDate_Click()
txtDate.value=atxDate.value
end sub

Luck
Jonathan
 
Thanks Jonathan
But, I don't see a click event in the ActiveX control I'm using. The only
events are:
On Updated, On Enter, On Exit, On Got Focus, and On Lost Focus. I can't
select and view properties for individual controls on the ActiveX calendar,
like Month and year selectors.
What am I missing?
Thanks
 
Back
Top