Progress Bar

[OuTCasT]

Can someone tell me how to use a progressbar to display when using a select statement.
jst to count the rows when i populate a form.

[ck9663]

Can someone tell me how to use a progressbar to display when using a select statement.
jst to count the rows when i populate a form.

That would depend on your front-end tool.

The basics steps are:

1. Create your connection.

2. Create your recordset.

3. Get the number of rows in your dataset.

4. Insert one row at a time to your form.

5. Update your progress bar.

-- CK

[CyberSoftHari]

I suggest you to insert in database itself like
Create stored procedure and write whatever query you need then execute that procedure.

Note: It is waste of time to bring the data from backend to front-end and again insert it to backend. (Your processes seem a huge data insertion to the database (Progressbar)!)

[debasisdas]

1.FInd out the number of records using COUNT.
2.Dispaly the progressabr to the number.
3.populate the data to frontend.