Outputting the status of the script...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Use Echo to display progress on the status line at the bottom of the
Access window.

HTH
 
Back
Top