Hi Guys,

I wanted to add a progress bar in my project. I don't remember which component I needed to add. I was looking for anything that resembles progress bar or any Active X control but I can't seem to find it. Can someone please help me add a progress bar to my project.

Thanks,
Judy

It's in mscomctl.ocx, that you can include using the Components dialog (Ctrl+T) selecting:

Microsoft Windows Common Control 6.0 (SP3)

or whatever service pack you have.

Marco

BTW I do not like that control at all. I prefer make my own using a simple PictureBox, because I can add much more flexibility.

Hi Macro,

Thanks. I was able to add it in. I am interested in what you said about creating your own using a picture box. Do you have any samples of code or any site that has this?

Thanks,
Judy

I set the BackColor and ForeColor of the PictureBox to something like White and Blue. Then I use the Scale property to set the range of the progress bar (equivalent to the Max property of the scrollbar) like:

picture.scale (0,0)-(maxVal,1)

if the progress bar is horizontal, otherwise

picture.scale (0,0)-(1,maxVal)

And then in the picture Paint event:

Picture.Line (0, 0)-(pValue, 1), , BF

(horizontal) where pValue is the current progress value.

This is the concept. Playing with the paint event, it is possible to get other fancy effects. I wrapped all the code in a nice class, so that I can add more properties as needed.

Marco

Hi Macro,

I'll play with this code. Thanks again for your help.

Judy

i have 15 table in 15 table i have to append some field in to one master table like below
table A
head of account(PK),date,dr,cr
table B
TID,details,name of subcriber,amount
table C
table D
etc....
in master table
i am append some record like head of account, name of subscriber, dr-cr=amount like all table
in all 15 table 1000 of records
now i wanted to add a progress bar when i am going click event in a form
Can someone please help me how to add a progress bar for click event in my form for appending
all records to main table

__________________
Mohamed Mohiddin
Officer

Hi

You can try something similar to the one below

Since you will be looping through each Table, iTabCnt will be the Table index (1 for first table etc)

Similarly iRecCnt wll be the record index

If you are sure about the total records and tables then you can have something like this



Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)