Solved Status Progress Bar Flashes During Recordset (1 Viewer)

pooldead

Registered User.
Local time
Yesterday, 17:57
Joined
Sep 4, 2019
Messages
136
I have implemented some code within my recordset to display a progress bar that will overwrite the "Running Query" message that flashes while cycling through my recordset.

The problem I've run into is that while this piece does work and display...

Code:
SysCmd acSysCmdInitMeter, "Updating...", rs1.RecordCount
n = n + 1
SysCmd acSysCmdUpdateMeter, n

...the default bar of "running query" will still flash behind my updated one. I would like to modify it so that only "Updating..." with its total progress bar appears.
 

pooldead

Registered User.
Local time
Yesterday, 17:57
Joined
Sep 4, 2019
Messages
136
I'm not sure I want one directly on my form, but could something like that be put into a message box that displays until recordset.eof?
 

isladogs

MVP / VIP
Local time
Today, 00:57
Joined
Jan 14, 2017
Messages
18,186
No. Message boxes halt execution until the user click a button on the message box.

I often use a progress bar in the form footer section so its easily visible but out of the way. Status progress bars are fairly small, easy to overlook, not very customisable and can have issues such as you described
 
Last edited:

pooldead

Registered User.
Local time
Yesterday, 17:57
Joined
Sep 4, 2019
Messages
136
Thanks isladogs! I'll give it a try in the footer.
 

pooldead

Registered User.
Local time
Yesterday, 17:57
Joined
Sep 4, 2019
Messages
136
So I gave up and just hid the status bar from File >> Options. Thanks for the help @isladogs!
 

pooldead

Registered User.
Local time
Yesterday, 17:57
Joined
Sep 4, 2019
Messages
136
Yeah, your suggestion did work, but my boss vetoed it lol. But at least I know something new that I can apply later on
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 17:57
Joined
Oct 29, 2018
Messages
21,358
Yeah, your suggestion did work, but my boss vetoed it lol. But at least I know something new that I can apply later on
Hi. In one of my personal apps, I put a pseudo progress bar as a status code in the footer section of the form. Since I always have the form opened at full screen, it sort of like the reqular status bar (I even adjusted the background color to blend). Maybe you can do the same thing using Colin's suggestion as a subform in the footer section? Just a thought...
 

smig

Registered User.
Local time
Today, 02:57
Joined
Nov 25, 2009
Messages
2,209
Im using a "progress bar" form.
It has no buttons, and i close it when job end.

In some cases im using a progress bar on the form, as Isladogs suggestet.
 

Users who are viewing this thread

Top Bottom