Status Bar Message

[Gerry]

I have several sql queries that run in sequence in VB code.
I am wondering if there is a way to change the status bar message to reflect
which query is running.
When each query runs, access shows "Run Query" and a progress meter.
I would like to change the text "Run Query"
Is this possible?
Thanks!!!!

 

[Maurice]

Personally i never change the statusbar text so it's just a quick test but
try something like:

Application.SysCmd acSysCmdSetStatus, "Yourtext here..."

I think it might lead you to something usefull maybe..

hth

 

[Gerry]

Thanks Much!!! It worked for what I needed.

Personally i never change the statusbar text so it's just a quick test but
try something like:

Application.SysCmd acSysCmdSetStatus, "Yourtext here..."

I think it might lead you to something usefull maybe..

hth

 

[Maurice]

Great that's what we like to hear ;-)

 

[Tony Toews [MVP]]

I have several sql queries that run in sequence in VB code.
I am wondering if there is a way to change the status bar message to reflect
which query is running.
When each query runs, access shows "Run Query" and a progress meter.
I would like to change the text "Run Query"

My comment is that I never notice the status bar as it is so small
starting in Access 95. So how can I expect the users to notice it?

Thus I now use a custom form such as the following:

Instead use some rectangle controls on a form. See the Progress Bars
and Microsoft Access page at
http://www.granite.ab.ca/access/progressbar.htm for more info.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/