Hey everyone!

I'm wondering if anyone has any input on where to find/buy a good application/plugin/activex control that will allow me to easily and quickly create progress bars within my access applications.

I realize that i can create them myself, but it's too time-consuming to try to incorporate that into my existing code. I also am having trouble with the activeX options in finding documentation and/or examples of how to use them.

I would ideally like some control or piece of code that i can put into a module then re-use with different parameters.

thanks!

mike

All you really need for a progress bar is a display element (a textbox formatted using a font that provides a square box, for example, or a drawing rectangle (inside a border rectangle) whose length you can adjust).

Then, all you need is a way to adjust the length of the rectangle (or the # of boxes displayed in the textbox). You can write a simple public sub to which you pass the name of the form, the name of the control, and the desired length (say, as a % of 100%) and it can do the work for you. Now, all you have to do is call that one routine, passing in the necessary parameters.

If you need help, let me know and I'll try to mock something quick up to demo this.

I went ahead and made a quick sample. There are two forms; one uses a textbox and WingDings font, the other a rectangle. Both call one global procedure to set the length.

Also check my sample in the code archive!
HTH
Good luck

Peter and Oliver,

I added the information provided from both of you to my Progress Bar page here:

http://home.bendbroadband.com/conradsystem...ogressbars.html

Any objections to having it there?

Thanks,
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystem...cessjunkie.html
http://www.access.qbuilt.com/html/articles.html

thats the way i do it. posted it months ago to the samples forum but somebody thought its not good enough for the
archive
i use it in all my apps.

All yours!

Thanks Oliver!

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystem...cessjunkie.html
http://www.access.qbuilt.com/html/articles.html

hi guys,

freakazeud - am i missing something here? i'm not altogether familiar with acc2000 but i can't seem to get to the code. what's the trick?

thanks,
mike

nevermind, i got it