Link to home
Start Free TrialLog in
Avatar of rdevriend
rdevriend

asked on

Status bar messages

Is there a way to stop MS-Access defaults messages, such as "Calculating...", "Run query" without hiding the status bar.

Regards,
Rene
ASKER CERTIFIED SOLUTION
Avatar of Gatsby
Gatsby
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rdevriend
rdevriend

ASKER

Gatsby

I already tried that one, but it doesn't work in the way I want. In a complex part of my program, a lot of queries (adding, deleting, updating) are performed. This process takes about 30 seconds. Each query itself shows "Calculating...", "updating", etc which causes a lot of flashing messages in the statusbar. Now, with the SysCmd, you see "Hi there" flashing between the other messages. That's why I want to get rid of the default MS-Access messages, but SysCmd is not doing that.

Any other suggestion?

regards,
rene
Hi Rene

Sorry...Didn't read your question right the first time...

This will clear the status bar for some of the default messages but I don't think it will work for what you are looking for.

Call SysCmd(acSysCmdSetStatus, "  ")

Also, when running queries, don't use the DoCmd.OpenQuery method...instead use something like....

Dim db As DAO.Database
Set db = CurrentDb
Call SysCmd(acSysCmdSetStatus, "   ")
db.Execute "UPDATE tblTest SET FieldTest = 1;"
db.Close
Set db = Nothing

This won't give you the status bar.

Gatsby
Gatsby,
Thanks, that was the trick, using db.Execute instaed of Docmd.OpenQuery. Here are the points.

Regards,
Rene