Status Bar Problem

  • Thread starter Thread starter Brian Hamilton
  • Start date Start date
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.
 
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?
 
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...
 
Back
Top