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 - 20 Jan 2006 21:12 GMT
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.

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
> Hi Guys.
>
[quoted text clipped - 18 lines]
>
> -Michael
Larry Daugherty - 20 Jan 2006 22:26 GMT
Use Echo to display progress on the status line at the bottom of the
Access window.
HTH

Signature
-Larry-
--
> Hi Guys.
>
[quoted text clipped - 15 lines]
>
> -Michael