By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,720 Members | 2,096 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,720 IT Pros & Developers. It's quick & easy.

Form won't Update while program runs

P: n/a
I have a large program that in some respects is like a large Batch file. It
acquires data from servers, spreadsheets and ascii files and loads the final
output to a large set of spreadsheets.

To keep track of where it is in the long process, I put a list box on a form
and built a simple messaging system to load the activities and time of each.
The sub procedure that handles that requeries the control each time there is
a new action reported.

Everything works fine EXCEPT the list box does not update until the program
terminates. Then it suddenly fills with hundreds of transactions.

Any ideas how to get it to update the screen as the database gets updated.
(The list box is fed from a query against a db).

Is there a better way of getting the desired effect (IE timely notice of
activity).?

Thx
Kevin
Jan 1 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Kc-Mass wrote:
>I have a large program that in some respects is like a large Batch file. It
acquires data from servers, spreadsheets and ascii files and loads the final
output to a large set of spreadsheets.

To keep track of where it is in the long process, I put a list box on a form
and built a simple messaging system to load the activities and time of each.
The sub procedure that handles that requeries the control each time there is
a new action reported.

Everything works fine EXCEPT the list box does not update until the program
terminates. Then it suddenly fills with hundreds of transactions.

Any ideas how to get it to update the screen as the database gets updated.
(The list box is fed from a query against a db).

Is there a better way of getting the desired effect (IE timely notice of
activity).?

After the Requery, try using the Repaint method. If that
doesn't do it, try adding one or two DoEvent statements
before and/or after the Repaint.

--
Marsh
Jan 2 '07 #2

P: n/a
That worked like a charm. You're brilliant!
Thx

"Marshall Barton" <ma*********@wowway.comwrote in message
news:c6********************************@4ax.com...
Kc-Mass wrote:
>>I have a large program that in some respects is like a large Batch file.
It
acquires data from servers, spreadsheets and ascii files and loads the
final
output to a large set of spreadsheets.

To keep track of where it is in the long process, I put a list box on a
form
and built a simple messaging system to load the activities and time of
each.
The sub procedure that handles that requeries the control each time there
is
a new action reported.

Everything works fine EXCEPT the list box does not update until the
program
terminates. Then it suddenly fills with hundreds of transactions.

Any ideas how to get it to update the screen as the database gets updated.
(The list box is fed from a query against a db).

Is there a better way of getting the desired effect (IE timely notice of
activity).?


After the Requery, try using the Repaint method. If that
doesn't do it, try adding one or two DoEvent statements
before and/or after the Repaint.

--
Marsh

Jan 2 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.