Outputting the status of the script...

[Michael]

Hi Guys.

I was wondering if someone could help me. I just wrote a rather length VB
script that takes a table does a bunch of queries, modifies the data, and
exports the new data to excel. I justed added a form so all my boss has to do
is push a few buttons to run the code... However, my boss would like to have
a little status window so he knows when each step is complete.

I have debug statements for me to see in the code... but I have no idea how
to do this for the user to see... I mean maybe you could add a msgBox for
each step, but then they would have to hit ok...

Does anyone know how to do this like an install file would?

I would really appreciate any assistance you could provide.

Thanks,

-Michael

 

[Douglas J. Steele]

Take a look in the Help file at the entry for SysCmd. You can use the SysCmd
function to write to the status bar.

Alternatively, you can put a label or text box on the form, and write to it
instead of using Debug.Print.

 

[Larry Daugherty]

Use Echo to display progress on the status line at the bottom of the
Access window.

HTH