Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Progress Bar 1

Status
Not open for further replies.

campbere

Technical User
Oct 10, 2000
146
US
I want to use a progress Bar for a report that I am creating. I want to show the progress as the report is being generated. The report is generated by evaluating X records which are cycled through in a for loop. Can someone explain to me how to use the progress bar so I can show percent or number of records that have been processed each time a record has been evaluated?

Basically if I have 4 records when the first record is complete I want the progress bar to show 1 record complete out of 4 or 25% complete, or possibly both. Each time it loops to the next record say record 2 I want it updated to show 2 records complete or 50%.

I appreciate the help.
 
ie.
PGB.Max = rst.RecordCount

do until rst.eof
'Code to do something
pgb.value = pgb.value + 1
.movenext
Loop
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top