By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 927 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

How to display messages when a macro is running multiple queries

P: 1
I have a macro that runs multiple queries. (using Access 2007)

I want to display on the status bar which query is running so I know where it's at in the process (the macro runs 47 queries).

I've tried Echo on, Echo off, added status bar text. All I get is the hourglass and maybe that little green progress bar, but I don't know which query is running.

Anyone know a way to display different messages while the macro is running?

Thanks
May 1 '12 #1
Share this Question
Share on Google+
4 Replies


zmbd
Expert Mod 5K+
P: 5,397
@Justinidea
Are the queries ran in series or are the queries subqueries?

-zmbd
May 11 '12 #2

NeoPa
Expert Mod 15k+
P: 31,419
If you look in Context-Sensitive Help for "Echo" (from Application.Echo()) you'll see the parameter bstrStatusBarText. Be very careful with using Echo(False) though. It can be very confusing when nothing you do shows on the screen - especially confusing when the code has stopped running.
May 11 '12 #3

Rabbit
Expert Mod 10K+
P: 12,357
Don't UI updates not happen until the end of code? Or is it different for macros? You'll probably have to use an asynchronous approach to running your queries.
May 11 '12 #4

NeoPa
Expert Mod 15k+
P: 31,419
Rabbit:
Don't UI updates not happen until the end of code?
Only if you set it to False. I used to use that method until I designed myself a [frmProgress} form to allow the list of jobs to be listed and ticked off as the jobs progressed.
May 12 '12 #5

Post your reply

Sign in to post your reply or Sign up for a free account.