code for progress bar

[miruna]

I'm trying to show the progress of a macro and I have
include in my form a progress bar. Can someone help me to
make it to work?

thx in advance

 

[Kevin]

Try using a sample progress bar from this site...
http://www.datastrat.com/Download2.html

Download the <<ProgressBark2K>> database and see if that helps. I just hide
the text boxes and set the form timer to count up to 100. I like it better
than using ActiveX. Just experiment with it.

-Kevin

 

[ALESSANDRO Baraldi]

I'm trying to show the progress of a macro and I have
include in my form a progress bar. Can someone help me to
make it to work?

thx in advance

You have many kind of way to reproduce Progress_Bar.
My favorite is using ComCtl32.dll.
Readin in www.mvps.com Access Links you can find many
running exemple.

Alessandro.(IT)

 

[john]

ia am john from Greece

It's more simple to insert an ActiveX object names "Microsoft Progress Bar" into your form.
Set the name of the progress bar from the properties sheet (for example fmProgressBar) and write a simple code in VBA

fmProgressBar.Value = 0 'initialize
fmProgressBar.Max = 50
for i=0 to 50
fmProgressBar.Value = i
for j=0 to 2000 'just delay
next j
next i

 

[miruna]

Alessandro, I couldn't find what I was looking for.

 

[ALESSANDRO Baraldi]

Alessandro, I couldn't find what I was looking for.

Look in our Italian Site:

www.sitocomune.com

Section Modules the First exemple is mine...!

Alessandro.(IT)

 

[Cheryl Fischer]

You might want to download the sample MDB file containing progress bar
samples created by Access MVP Sandra Daigle. Here is a link:

http://www.daiglenet.com/MSAccess.htm

 

[Scott McDaniel]

This is assuming you have the license for this control. You can certainly
use it on your machine, but if you don't have the license to distribute it,
when you transfer your db to another machine you'll run into troubles.
Better, by far, to use the API calls or build your own with textboxes and
labels.

ia am john from Greece

It's more simple to insert an ActiveX object names "Microsoft Progress Bar" into your form.
Set the name of the progress bar from the properties sheet (for example

fmProgressBar) and write a simple code in VBA