Today's date on an Active X Calendar

C

CEL504

Could anyone tell me how to set the properties so that the ActiveX calendar I
have in the database, displays the current date when the program is openend.

I thought this would have been easy, but obviously not!

Thanks for any help.
 
C

CEL504

James, thanks for the response, but I am still at a loss as what to do. Could
you explain further?

Cel504
 
J

James A. Fortune

CEL504 said:
James, thanks for the response, but I am still at a loss as what to do. Could
you explain further?

Cel504
Click to expand...

The important point is that the ActiveX Control's AfterUpdate event does
not show up in the list of events. You have to add 'Private Sub
ActiveXControlName_AfterUpdate()' yourself in the VBA window, set the
textbox's value to 'ActiveXControlName.Value' in the subroutine's code
and have faith that the ActiveX Control will know what to do with the
event when a day is picked.

The locked textbox shows the user what date will be used, yet doesn't
allow the user to type in a date and possibly put in an invalid date.

James A. Fortune
[email protected]
 
Top