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
+ 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 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
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 outof colored rectangle to go on a form, varying its width say betweenzero and 3-inches with the actual width being directly proportionalto the percentage calculated by calculating the form's current recnum 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 I wasn't aware I could embed that on a form. >What's the matter with the standard MS ProgressBar? Is theresomething it will not do that you need? I remember seeing an examplefrom Albert K, and they're really easy to implement if you just use acanned one. If that won't work for you, you might check the usualplaces - Stephen Lebans' site, etc. Not sure you can set the size ofthe 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.