European Experts Exchange (EEE.org) :: Free Experts PHP MySql Oracle Microsoft Web SQL Delphi


Languages :: VBA (Office) :: Best Practices for Form Events
By: knechod	Date: 24/12/2004 01:11:30	Points: 20	Status: Answered Quality : Excellent
When I instantiate a new copy of a form using the New keyword, it fires the Open, Load, Activate, and Current events immediately. This has caused a lot of workarounds in code that look terrible! How would you characterize the types of activities that should be performed in each of these? Thanks, Kevin
By: VGR	Date: 29/12/2004 09:31:02		Type : Answer
From what I read on google/microsoft, this is perfectly normal. Open, Load and Activate are triggered in sequence as explained on http://msdn.microsoft.com/library/en-us/bapp2000/html/acbachap05.asp The Current event has even the sequence : Open → Load → Resize → Activate → Current On the top-right section of http://www.blueclaw-db.com/access_event_programming/index.htm, you'll probably find "Form Event Examples" that will help you understand and master the event handling in your FORM. On "How to create an event handler?", I suggest reading this : http://www.samspublishing.com/articles/article.asp?p=21321&seqNum=3 As far as I can humbly tell, all the chapter under the statement "VBA event procedures (also known as event handlers) are subprocedures contained in class modules" is very interesting to you. Best regards and sorry I don't have enough VBA knowledge myself to better answer your question.

By: Nono	Date: 17/05/2005 16:02:56		Type : Comment
I think you did answer it right, buddy.

By: VGR	Date: 19/05/2005 08:32:10		Type : Comment
time for knechod to close the Question, then ? ;-)

By: VGR	Date: 21/07/2005 12:19:50		Type : Comment
?

By: Nono	Date: 26/07/2005 12:24:01		Type : Comment
strange, isn't it ? May-be you should force-close this question and assign the answer to yourself (despite how much uninethical this may seem at first ;)

By: VGR	Date: 26/07/2005 17:22:52		Type : Comment
thanks knechod ;-) I hope we can help you again sooner or later ;-)

Do register to be able to answer

©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page! Post to Plurk Post to Yahoo Buzz Post to Delicious Post to Digg Post to MySpace Post to Ping.fm Post to Reddit Post to StumbleUpon

Contact

page generated in 307.875870 milliseconds

Why Google AdSense ads ?

New Improved Search!