Status Bar Problem

B

Brian Hamilton

Hello All,

I am using SysCmd() to display a progress bar in the status bar while I loop
through some data manipulation routines. The problem is that if a query runs
(using Docmd.RunQuery) within the loop the progress bar is over-written. Is
there a function, method, code etc... that prevents the status bar from
displaying the messages associated with an action query being run? The
"Cocmd.SetWarnings False" call doesn't affect the status bar.

Thanks in advance,
Brian Hamilton.
 
D

Douglas J. Steele

Don't know for certain (because I haven't bothered testing it), but what
happens if you use the .Execute method to run the query, rather than
..RunQuery?
 
B

Brian Hamilton

Thanks Doug, spot on.

Douglas J. Steele said:
Don't know for certain (because I haven't bothered testing it), but what
happens if you use the .Execute method to run the query, rather than
.RunQuery?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prevent interruption of status bar meter 7
displaying messages in the Status bar with the Status command 2
Trap status bar changes 2
Status Bar Message 4
Progress bar 2
Why doesn do I show connection status in the Status Bar? 3
Status Bar in Windows Mail 6
I recently lost send/receive progress in the outlook status bar, 1

Top