I am writing an application in VB, which requires to be in a loop for what could be a long period. The program goes through the following steps:
Loads A Form
( the form has two buttons Start and Stop )
If the user clicks on start the programs calls a function as to do the following:
Opens a server based SQL database
Checks that new records exist
Gets a set of records using a Query
Updates a second server based database
Displays various Output on Form
The problem I am having is that once in the loop, the program does not respond to any input and its not possible to use the stop button, move the form, close the program etc.
I would appreciate if anyone could assist in outlining how I can keep the program responding to user input one inside a loop.