Form won't Update while program runs

[Kc-Mass]

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

[Marshall Barton]

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

[Kc-Mass]

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