Forms sticking VB6
-
I am having a problem where I am importing/exporting rows from one database into another and there are approximately 500 rows with data. The user clicks on a button to import and the form sticks up until such time as the processing completes (import/export all rows) which takes like a minute. The processing goes through a couple tables to get data for the processing and takes too long (like 1 - 2 minutes) and all the forms stick up while processing. Any suggestions for improving having some sort of progress bar/ preventing the forms from sticking on this would be greatly appreciated! I am using recordset queries to get data to do all the comparisons etc. for import/export..
-
I am having a problem where I am importing/exporting rows from one database into another and there are approximately 500 rows with data. The user clicks on a button to import and the form sticks up until such time as the processing completes (import/export all rows) which takes like a minute. The processing goes through a couple tables to get data for the processing and takes too long (like 1 - 2 minutes) and all the forms stick up while processing. Any suggestions for improving having some sort of progress bar/ preventing the forms from sticking on this would be greatly appreciated! I am using recordset queries to get data to do all the comparisons etc. for import/export..
Hi,, as you are using recordsets to transfer data you can use
Doeventsfunction before each call toMoveNext.. this gives the form the ability to process messages (Events) using a progress bar is a good idea.. -
Hi,, as you are using recordsets to transfer data you can use
Doeventsfunction before each call toMoveNext.. this gives the form the ability to process messages (Events) using a progress bar is a good idea..