Form Open How Long Function - Access Developers


	Back to Access Developers Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Form Open How Long Function

Werner Mildt

2 months ago

In my calendar form I am using already the
On Open and the On Close Event for code to makes the calendar work.
Question?
Is there a way I could use Rick's
FormOpenHowLong Code Function.
I looked at
On Activate and On DeActivate
but I am not Shure it will work.
Would Appreciate any input.

Form Event On Open =NoteTimeOpened([Form])
Form Event On Close =NoteTimeClosed([Form])
Thanks

	Kevin Robertson @Reply 2 months ago
Just call the functions in the VB Editor and replace [Form] with Me. You do need the `Call` keyword. `Private Sub Form_Close() Call NoteTimeClosed(Me) End Sub Private Sub Form_Open(Cancel As Integer) Call NoteTimeOpened(Me) End Sub`

	Werner Mildt OP @Reply 2 months ago
Thanks Kevin, This works just perfect. Many thanks again Werner

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developers.

Next Unseen