>>I tried creating a form(mini in size) with a Progress Bar and a Timer controls.
>>I run a Form and when I click a Confirm button, I immediately show the
>>Progress Bar mini form and execute a few SQL statements(eg INSERT, DELETE,etc).
>>I discover that the Progress Bar doesn't move(suppose to move the % complete).
>>I guessed that it is because of the some SQL statement tasks are running in
>>the background, that stops the Progress Bar control from running.
>>
>>How can I achieve the effect of having both the main Form SQL statements
>>running and also the Progress Bar running? Pls advise on a better method.Thnks.
>
>Do you refresh your progress bar? You can also try to put some DoEvents.

I used a Timer of 1 sec to add the percentage of the Progress Bar control.
I did tried to put the DoEvents after each SQL execute statement.
What else could went wrong. The Progress Bar didn't even move a little.
Pls help, thanks.