Calender Control. After update event not displayed in Properties 1

[MissyEd]

Hi all

I'm looking to use this calender control :- OLE class Calendar, Class MSCAL.Calendar.7 but the afterupdate event isnt displayed in the properties list for some reason.

Im attempting to use functions e.g "After Update" = do-stuff-functon(), instead of creating a module within the form. Im hoping this will make the debugging etc easier.

Im loath to create a form module, but is this the only way to access the AfterUpdate event or do I need a more up-to-date version of this control? Unfortunately, the "On Updated" event is no longer used by MS Access 97, so I cant put the function there.

Any assistance gratefull received as usual

Missy Ed
Looking to exchange ideas and tips on VB and MS Access development as well as office 97 development. Drop me a line: msedbbw@hotmail.com

 

[Claude55]

I think you may have to create a form module, not sure why you dislike them. I'm not sure if it will work for the after update event, but you'll notice that the calendar control doesn't list an On_Click event. Yet, if you open any of the events you can then go in and create your own On_Click event and it will work.

For example, I have a calender control named Inspection Date, created a sub procedure like this:

Private Sub InspectionDate_Click()
On Error GoTo InspectionDate_Click_Err

Me.evaluatorunbound.Visible = True
DoCmd.Requery "date"

InspectionDate_Click_Exit:
Exit Sub

InspectionDate_Click_Err:
MsgBox Error$
Resume InspectionDate_Click_Exit
End Sub
_________________________________________________

and it works! I have to credit Susan Sales Harkins for her Access Tips at Topica.com for this trick.

 

[MissyEd]

Thanks Claude

I'll give it a whirl Missy Ed
Looking to exchange ideas and tips on VB and MS Access development as well as office 97 development. Drop me a line: msedbbw@hotmail.com