Event procedures
am 22.10.2007 19:57:33 von u33878
Is there somewhere I can go to find out exactly what all the "event" names do?
For example, when exactly does the "on dirty" event happen or "on focus", etc.
.. Is ther a list out there somewhere?
Thanks
Bill
--
John 3:16 "For God so loved the world that He gave His only begotten Son, so
that whoever believes in Him shall not perish, but have eternal life"
Message posted via http://www.accessmonster.com
Re: Event procedures
am 22.10.2007 21:14:46 von Rich P
Hi Bill,
The easiest way to learn what events are fired when is to select each
event you need to work with from the Events dropdown box on the form's
class module. Then place a messagebox call for each event
msgbox "OnDirty Event"
...
...
msgbox "OnFocus Event"
...
Note: the messagebox may interfere with some events firing completely
(or at all) because of the modalness of the messagebox. In that case
you can do a debug.Print for each event and look at the debug window.
Some events (like the OnCurrent event) will fire for anything you do on
the form and you will either have dozens of messageboxes (more like
hundreds - to the point where you have to ctrl-alt-del to shut down the
medb) or you might get lots of debug.prints - but you don't have to shut
down for debug.print because that will execute right on through and just
write out your message to the debug window.
Rich
*** Sent via Developersdex http://www.developersdex.com ***
Re: Event procedures
am 24.10.2007 03:36:13 von DM McGowan II
Each event it explained in the online help. You can just put the cursor in
the event in the properties window and press F1. Or just do a search in
online help. It's pretty good at explaining it. It also explains them in
groups (beforeinsert, afterinsert, beforeupdate explained together; etc.).
Another thing you can do is put a MsgBox command in each event, with simply
the name of the event coming up in the message box. That could be a little
annoying, but it would show you how they fire, and in what order.
Neil
"bhrosey via AccessMonster.com" wrote in message
news:7a14f3890a3bc@uwe...
> Is there somewhere I can go to find out exactly what all the "event" names
> do?
> For example, when exactly does the "on dirty" event happen or "on focus",
> etc.
> . Is ther a list out there somewhere?
>
> Thanks
>
> Bill
>
> --
> John 3:16 "For God so loved the world that He gave His only begotten Son,
> so
> that whoever believes in Him shall not perish, but have eternal life"
>
> Message posted via http://www.accessmonster.com
>