Status Bar

[Guest]

Hello all,

I would like to use a status bar (active x, I guess) while I am running some
code. The type that increments, like when you are loading software or
something. I am using access 97. Could someone steer me in the right
direction on how to do this, or some, links to some answers?

 

[Graham Mandeno]

Hi Mark

Have you tried the built-in progress meter?

Here is an example of its use:

Call SysCmd(acSysCmdInitMeter, "Processing records", rst.RecordCount)
Do Until rst.EOF
Call SysCmd(acSysCmdUpdateMeter, rst.AbsolutePosition)
' do something with a record
rst.MoveNext
Loop
Call SysCmd(acSysCmdRemoveMeter)

 

[Jeff Conrad]

In addition to Graham's suggestion, see this page on my site
for several options:

http://home.bendbroadband.com/conradsystems/accessjunkie/progressbars.html

--
Jeff Conrad
Access Junkie
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[Guest]

Thanks all! Just what I needed...