>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.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com