By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,145 Members | 1,590 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,145 IT Pros & Developers. It's quick & easy.

Seeking makeshift progress bar for use on a form

P: n/a
MLH
Was wondering if anyone has constructed a progress bar out
of colored rectangle to go on a form, varying its width say between
zero and 3-inches with the actual width being directly proportional
to the percentage calculated by calculating the form's current rec
num divided by the number of records in the source table?

If so, would U-care to share your work with this NG?
Nov 30 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a

MLH wrote:
Was wondering if anyone has constructed a progress bar out
of colored rectangle to go on a form, varying its width say between
zero and 3-inches with the actual width being directly proportional
to the percentage calculated by calculating the form's current rec
num divided by the number of records in the source table?

If so, would U-care to share your work with this NG?
What's the matter with the standard MS ProgressBar? Is there
something it will not do that you need? I remember seeing an example
from Albert K, and they're really easy to implement if you just use a
canned one. If that won't work for you, you might check the usual
places - Stephen Lebans' site, etc. Not sure you can set the size of
the MS one, if that's the problem. But then I never tried, either.

Nov 30 '06 #2

P: n/a
You can also try some of these:
http://home.bendbroadband.com/conrad...gressbars.html

MLH wrote:
>Was wondering if anyone has constructed a progress bar out
of colored rectangle to go on a form, varying its width say between
zero and 3-inches with the actual width being directly proportional
to the percentage calculated by calculating the form's current rec
num divided by the number of records in the source table?

If so, would U-care to share your work with this NG?
--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200611/1

Nov 30 '06 #3

P: n/a
MLH
I wasn't aware I could embed that on a form.
>
What's the matter with the standard MS ProgressBar? Is there
something it will not do that you need? I remember seeing an example
from Albert K, and they're really easy to implement if you just use a
canned one. If that won't work for you, you might check the usual
places - Stephen Lebans' site, etc. Not sure you can set the size of
the MS one, if that's the problem. But then I never tried, either.
A handy work-a-round I did was to put a couple of rectangles on a
form - 3" long and a quarter-inch high. Both were identical size and
location - superimposed on top of each other. Box on bottom I named
RedBar and box on top I named GreenBar. On opening the form I set
GreenBar's width property to zero. As the user moves record to record,
I increase or decrease the wdth property ofthe box proportionally to
how far 'into' the recordset the current record pointer is. Initially,
it looks like there's just 1 red bar. Moving from first to last record
in set, GreenBar gets longer and longer and appears to be growing
in length to the right, covering up RedBar as it goes until covering
it all the way up when the last record is reached.

I use it as a visual aid for data entry clerks doing long & laborious
hours of work to a data file. It helps to give them some sense of
accomplishment.
Dec 1 '06 #4

P: n/a

MLH wrote:
Was wondering if anyone has constructed a progress bar out
of colored rectangle to go on a form, varying its width say between
zero and 3-inches with the actual width being directly proportional
to the percentage calculated by calculating the form's current rec
num divided by the number of records in the source table?

If so, would U-care to share your work with this NG?
MLH,

I have one this does pretty much what you asked. I've been
distributing it for a couple of years on this NG. If you write me
direct, I'll send you a demo application. I have A97 and A2000
versions.
ha********@aol.com

Hank Reed

Dec 1 '06 #5

P: n/a
Grab the one from my super easy mail merge.

It has a few things going for it:

1st, it actually looks like progress bar.

2nd, it has provisions for setting the max, and min, and then you inc it
each time through your loop, and it figures out the progress.

You can find here:

http://www.members.shaw.ca/AlbertKal.../msaccess.html

(grab the super easy mail merge...try runnning it..there is a "prgress bar"
demo butiton on teh form....)

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Dec 1 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.