progress bar

[waqas]

i am making a new table with make a table query

i want to see how many record are inserted by using progress bar

any one can tell me how can i use progress bar and which activex control.:beerchug:

[orange]

There is a video tutorial here that may give you some ideas:
http://www.datapigtechnologies.com/flashfiles/progressbar.html

[waqas]

Thanks for this link.

this is acting when a query is finished.

but i want to get data in between query because i am using make table query its get data from other source and put into new destination.

i want to know between source and destination how much record are inserted.

i think my point is clear now.:friends:

[waqas]

Dear Experts,

kindly have a look at my below request:help

this is acting when a query is finished.

but i want to get data in between query because i am using make table query its get data from other source and put into new destination.

i want to know between source and destination how much record are inserted.

i think my point is clear now.:friends:

[HiTechCoach]

Have you tried using the .RecordsAffected ?


Example


Dim strSQL As String
Dim db As DAO.Database

Set db = CurrentDb

strSQL = " << Action qurey here >>"

With db
.Execute strSQL, dbFailOnError
MsgBox "Number of Records Affected: [" & .RecordsAffected & "]"
End With