Create a "Progress" Bar...

[Joey_R]

I have a large database without navigation buttons on a Form. I would like to give my users an indication of how far they have navigated through the records by setting up a progress bar at the bottom of the form.

I thought of using the Percent Property of a recordset.

Any ideas...

Cheers
J

 

[AgentSmith]

Access does come with a built-in progress meter in the status bar at the bottom. Here's some info:

http://support.microsoft.com/?kbid=210474

However, if you still want to put it on the form then you should be able to specify "Min" and "Max" values for the progress bar. I'd set those to 0 and 100 respectively then you can set its value to 100 times the recordset's Percent property whenever they navigate to a new record.

Nice idea!

 

[Base]

Hi Smith,

How do you know what record you are on at any given time?
I played around with rec.absoluteposition but it doesn't seem to do the trick.

I thought of something like the following:
Dim PB as string
PB = "|||||..." (100 little lines)

And then making a field on the form = left (PB, rec.absoluteposition) or = left (PB, rec.persentaageposition) so that it would take up more of the 100 "|" each time you move to a new record.

Can you shed light on the position you are at in a recordset?

Thanx
Base

 

[pritcham]

Hi

take a look at the following which should help: http://support.microsoft.com/?kbid=304581

Martin