Is it Possible to Attach to Access' Status Bar?

[Guest]

Hello All,

I suspect the answer is no, but here goes....

I have a form which displays a simulated (i.e. MSKB 304581) progress meter
for a set of actions within the application. The meter works fine until;
except, for one step. At a point in execution, I'm running a stored query to
delete a set of records using DoCmd.OpenQuery.

Can I read/attach to Access Status bar to get the max and current values
whcih I could use to update my progress bar? I want to be able to indicate
the query's progress

Running the query updates the standard status bar in Access. The
DoCmd.OpenQuery method doesn't provide/return any mechanism for me to update
my progress bar.

Currently, I just display static text at the time the query is run informin
g the user to wait, the progress bar will not update, and the stage may take
up to a minute to complete.

 

[Armen Stein]

Hello All,

I suspect the answer is no, but here goes....

I have a form which displays a simulated (i.e. MSKB 304581) progress meter
for a set of actions within the application. The meter works fine until;
except, for one step. At a point in execution, I'm running a stored query to
delete a set of records using DoCmd.OpenQuery.

Can I read/attach to Access Status bar to get the max and current values
whcih I could use to update my progress bar? I want to be able to indicate
the query's progress

Running the query updates the standard status bar in Access. The
DoCmd.OpenQuery method doesn't provide/return any mechanism for me to update
my progress bar.

Currently, I just display static text at the time the query is run informin
g the user to wait, the progress bar will not update, and the stage may take
up to a minute to complete.

As you suspect, the answer is no, at least as far as I know.

I would just make sure the hourglass is on, set your progress meter,
then launch your query. Does the query show it's own progress meter in
the status bar? Doesn't that give a sense of progress?

Another alternative is to break up your delete query into pieces and run
them separately, updating the meter after each piece. Or running the
deletes individually from code, but that would be really slow. Seems
like a lot of effort to provide eye candy for 60 seconds.

 

[Guest]

Armen, thanks for the reply.

Access' progress meter with the status bar is really too small to be noticed
by the users. And you're right, the extra effort really isn't worth the
expense.

Again, thanks for your response,
Orlanzo