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

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

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,123,346
Messages
5,601,087
Members
414,426
Latest member
fraru

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top