Create a "Progress" Bar...

Joey_R

Board Regular
Joined
Sep 7, 2004
Messages
123
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
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

AgentSmith

Well-known Member
Joined
Mar 8, 2004
Messages
575
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

New Member
Joined
Oct 5, 2005
Messages
37
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,727
Messages
5,573,853
Members
412,554
Latest member
faridr
Top