Report progress of macros

[Sheryl]

I have a "Build All Tables" macro, which calls 8 macros,
each of which calls several queries. I would like to be
able to have a way to display the progress of all this.

The status bar displays little bar graphs "Run Query",
so 'Echo' doesn't work. I have tried using a Form based
on a table SYS_STATUS, which contains one record
describing the current operation. The table is being
updated ok, but the entry on the form does not
automatically update itself to changed values.

 

[Nikos Yannacopoulos]

Sheryl,

If I understand correctly, you're saying that although the
form is getting new data, it is not displaying it?
If that's the case: this happens because code execution
(action queries, recordset operations etc.) takes higher
priority than changes to forms. There is a workaround,
though... just add this line of code:
Forms("My_Form_Name").Repaint
right after every line of code that updates your form, to
force Access to refresh it.

Nikos