Access events

[TheShabz]

Hi all,

We can trigger VBA code on form events. Can we trigger them on Access application events? For example, can i trigger some vba code when i run a query? Reason I ask is that when I'm running a rather lengthy query, I really cant do much but sit there and wait for it to finish. It makes me look rather unproductive to those who walk by and don't know what's really going on. It doesn't help that Access' progress bar might as well not exist, as it is totally inaccurate. What I want to do is have a from with with a progress bar, more so like the windows start-up bar that shows that scrolls constantly rather than showing how much is done, every time I run a query.

While my use for this is rather stupid, it brings up the larger question of using Access events, rather than form events, to trigger code. Can this be done?

[orange]

From what I can find, it seems, because MS Access is single threaded, that you can not do other meaningful work while the query is running. I've seen posts where the person was advised to move to DotNet if multithreading was a requirement.
Just my $.02

[alansidman]

Mike Alexander in this video shows a concept that is interesting. Not sure how you would apply it to one query only however.

http://www.datapigtechnologies.com/f...ogressbar.html

Alan