Office 2010 Key Power Tip Use dynamic event callb

Today’s guest blogger is Joel Graff, Operations Field Engineer with the Illinois Department of Transportation.

Many of the Access projects I’ve developed have used VBA extensively, and the more I became involved in developing user interfaces, the more I saw a need to customize the behavior of the controls that Access provides.  Developing this sort of solution gave me the architecture to be able to develop much more complicated control interactions and aesthetics without getting lost in a mess of spaghetti code, ambiguous function references, and endless form/control qualifications.

A demo database is available here, so if you’re interested, download a copy and read on!

Here’s how the demo database works:

Rather than trapping a control’s event in a form module, I created a class module (referred to as a “control event handler”) which has all the event-handling stubs contained within.  Of course, the main member of this class is a local WithEvents reference to the form’s control.

Once the event is triggered in the control event handler, the handler then uses the Application.Run method to execute a callback function stored in a separate module.  The name of that function is passed to the event handler on initialization and can change at any time in the course of the program.  The control  event handler passes to the callback the reference to the control itself, an enumeration indicating the control’s type (in lieu of the ControlType property,Microsoft Office 2010 Product Key, which not all controls support), and a string describing the event which was triggered.  After that is a series of optional parameters containing anything that is passed back from the original event call (e.g., MouseMove has Button, Shift, X, and Y for parameters).

So why do it this way? In most cases, you probably won’t want to.  But here’s why I like it:
Once you’ve pushed the callback to a different module, you have to make sure the parameters you need are passed, and you’ll likely need to reference the original control.  This architecture allows me to standardize my callback declarations (or ‘signatures’).  That is, every callback has three basic parameters:  a reference to the control, an enumeration describing the control type, and a string of the event name.  Further parameters can be added to the signature for values that are returned by the event, or a blanket series of optional parameters can be added to every callback signature just in case. I don’t have to load a ton of functions when the form loads.  By separating the callbacks into separate modules, I reduce form-loading time. I can reuse my callbacks.  Of course, I can do this the standard way, as well.  But the standard way requires me to manage passing the parameters and control references from the form-level code to the callback.  These classes do all that for me.  I just need to provide a callback with standard signature and make sure I accommodate whatever extra parameters the target event will likely pass to it.  Further, the callback’s standard declaration provides me three things:  a direct reference to the control, an enumeration of the control’s type,Microsoft Office 2007 Professional, and a description of the event, simplifying the logic required to have a common callback process multiple events from multiple controls. Global callbacks can be implemented.  That is,Microsoft Office Pro 2010, if I want to implement a global callback that gets called anytime one form’s controls get called, or one type of control is called, or perhaps whenever *any* control is called (or any combination of these), I can do that. Type-checking / object validation / error-trapping, etc, that I don’t have to implement in every function that takes calls from an  event.
Some of the drawbacks include:

Increased complexity in the class implementation.  This comes especially because you cannot define one event handler to catch events from multiple controls.  For example, CommandButton, OptionGroup, and Form all have Click events,Office 2010 Key, but I’d have to create a separate event handler class for each control in order to trap their separate Click events.  However, the callback for their click events could all be the same function.  I should point out that once the classes are implemented, using the classes isn’t particularly complicated. Additional function calls.  Some would say this would cause performance bottlenecks,Microsoft Office Professional 2010, which may be the case.  As I see it, however, user-triggered events don’t happen very quickly, so I don’t see the additional overhead of the extra classes or using the *really* slow Application.Run method as really posing any problem.  In fact, in my general experience, even the MouseMove event (which would trigger most frequently) doesn’t really appear to suffer from this overhead. Application failures don’t recover very well.  Debugging is especially problematic as, quite often, when an error is encountered, VBA may let you fix it and continue, but the event handlers will quit responding.
The demo database gives a fair idea of how it works, but you need to explore the code to really understand it.  I have tried to comment it as thoroughly as possible.  Note the relative simplicity of defining an event handler and callback in the Startup module.  Also note the sparseness of code in the Form module.  In fact, the Form module could be completely empty in many cases.  However, you must have, at very least, an empty module for this to work.

The demo demonstrates changing a control’s callbacks on-the-fly, using a global callback, managing events at both the form and the control event handler class level, and managing all events through one common call-back function.


Joel Graff
Send your Power Tips to Mike and Chris at accpower@microsoft.com. <div

[l1ao6en3xai]

1. a small white rabbit hopped into the bakery and asked: \so ah... \
next day, the rabbit hopped to the bakery, \\
third day, the rabbit hopped to the bakery, \small bread!! \
on the road? encountered a giraffe are rolls of cannabis,
small white rabbit on the giraffe, said: \, let us run it in nature! \>
later? have encountered an elephant is ready to smoke cocaine,
the rabbit on the elephant, said: \> How wonderful to see the forest, let us run it in nature! \follow the white rabbit and giraffe running in the forest.

later? who are prepared to fight heroin encountered a lion,
the rabbit said to the lion: \their own thing?
to see how beautiful the forest, let us run it in nature! \,
rush to beat the meal the little white rabbit.
elephants and giraffes was trembling with fear: \told us to close to nature. \> 3. the first day, the white rabbit to the river fishing, caught nothing, go home.
next day the rabbit went to the river fishing, or catch nothing, go home.
third day, the white rabbit arrived in the river, a big fish to jump out from the river, directed at the rabbit shouted:
If you dare ######## with Hu carrots as bait, and I flat die for you!


4. In order to test the United States, Hong Kong, mainland China the strength of the three police officers, the United Nations three rabbits on three forest to see the three police officers who should find the rabbit.
The first is the United States before the forest police, they first spend a full half-day meeting to develop operational plans, strict division of labor, and sent special forces into the forest carpet-fast search, the results of the meeting time delay, the rabbit is gone, the mission fails!
Then turn to the Hong Kong police, who sent more than a number and dozens of police cars lined up outside in the forest, with speakers from the leader shouted: \....\baton into the forest, not five minutes, I heard an animal in the forest came a scream, one Chinese police talked and laughed out smoking a cigarette, dragged behind a black and blue bears, bears dying said: \to the rabbit ears in the two posts, saying \Rabbits are aggrieved dismissed.
next day, she wore a hat bounce out of the house, and met the wolf, and he took to \\Ponder for a long time, finally decided to go to king of the forest tiger complaints.
explained the situation, the tiger said, \Day, tiger wolf children recruited his buddy. \go! found her fat, you say you want to thin. She sent for thin, you say you want to fertilizer. This is not a thing can beat her. Of course, you can say that. Bunny over to the I find a woman to go. found her plump, you say you like slim. found her slim, you say you like plump. can beat her with a strong beat of the rational section. \Wolf nodded, clapping and cheering, the respect of the tiger rushed to a new peak again. Unexpectedly, the above guidance, are being weeding out the window to the Tiger family heard the little white rabbit. Mind the hate ah.
next day, the rabbit and then went out, how so clever, the face of approaching or timber wolf. Wolf said: \Another happy heart, said, fortunately there are B program. He added: \ruthless to the rabbit ears in the two posts. \> So bear to pick up the rabbit backside.



7. there is a wolf indecent assault of a rabbit (rabbit very right),
and then ran away, chasing the wolf angrily,
rabbit watch Wolf is about to catch up,
would sit down under a tree,
DAI Qi sunglasses, holding a newspaper to see,
pretend nothing had happened,
when the wolf came running and saw a rabbit sitting under a tree,
asked: \shouted: \
boss shook his head: \
next day the little white rabbit went to the shop to ask: \run.
the third day of the White Rabbit to the shop to ask: \! \
the fourth day of the White Rabbit to the shop, asked timidly: \you? \
black rabbit listening to \
next black rabbit went to the shop to ask: \br> black rabbit listening to \
the third day of black rabbit went to the shop, asked timidly: \have carrots? \
fourth day of the black rabbit went to the shop, vague asked: \I hope you have a long neck to know how good. no matter what good to eat, I eat is going to be slowly through my long neck, it can be a long time to enjoy delicious. \look at him.
\said: \the ground seemed to listen to what ...
kangaroos stopped .. so very curious to ask: \.. \>
11. ant walking in the forest, suddenly encountered an elephant, the ant quickly dived into the earth, stretching out a leg.
rabbits met very curious and asked: What are you doing?
ant it said quietly:
... Hush Hush ... to see if I stumble Ah a somersault ... ...


12. One day the hare before the write stuff in a cave, a wolf came over and asked: \Q: \
rabbit said: \Then came a fox and asked: \said: \
rabbit said: \
inside the cave at this time a lion was sitting on a pile of bones picking his teeth, the paper also watching the rabbit: the ability of an animal the size of its force not to see how much, but look at it Who is the boss behind the scenes!


13. in a mental hospital, one day the three Presidency would like to see how the recovery of mental patients, so before each of them put in a little white rabbit, the first mental rabbit sitting on top of the patient, grabbing the rabbit's ears, mouth shouting \Lane said \put you 300 meters, so I rub my car catching you! \
Big Bear on the rabbit, said: Although rabbits you look good, but I could trouble! stained points dirt can tell, quite disgusting,团购网!
rabbit wrote: What are you talking! is not ah!
Big Bear wrote: not so! Big Bear said as he took the rabbit to himself readily wiped his ass walk away


15. a small white rabbit and large bear walking in the forest, accidentally kicked over a pot.
pot out of a spirit, that they meet all three wishes.
bear said, turning it into the world's strongest bear. It has come true.
rabbit said, give it a little helmet. Its desire to achieve.
bear said, turning it into the world's most beautiful bear. It's the wish came true.
rabbit said, give it a bicycle. It's the wish came true.
bear said, the whole rest of the world into a mother bear bears!
rabbit riding a bike, running while said, the only bear into a gay ... ...


16. three little rabbits to a mushroom
collected two large to small, get some vegetables to eat with little to say
I leave you I do not eat my mushrooms a
two large rest assured that it will not go to the little white rabbit went to the ~ ~ ~
the rabbit has not come back six months later a large door that it is not coming back I eat the
Another big say wait it ~ ~ ~
year later the white rabbit has not come back to discuss the two big so we do not have to eat it
Just then the little rabbit suddenly jump out from the jungle next to that angry look! I know you want some of my mushroom ~ ~ ~