Application Progress Screen

[Bill]

Is there an application out in the wild that
essentially mimics the Microsoft step-by-step
display when one "reports a failure" to
Microsoft?

I suppose I could build one using a form, but
wouldn't bother if there's already an app.
available.

Thanks,
Bill

 

[Tony Toews]

Is there an application out in the wild that
essentially mimics the Microsoft step-by-step
display when one "reports a failure" to
Microsoft?

I suppose I could build one using a form, but
wouldn't bother if there's already an app.
available.

You want to be notified If the user hits an error in the VBA code? If
so in your error handling routine write the user name, date/time,
error message and form/report/module name and procedure name to a
table.

(Hint: Do not put this code in your error handling routine. There
just display the message. A recursive error if there is a problem in
the error handling routine is an ugly thing to figure out what is
happening.)

MZTools can be of assistance here as it can paste in error handling
code of your choice along with the form/report/module name and
procedure name. Note though that if you change the form, report or
module name or the procedure name you will need to manually change the
error handling code to have the new name.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

 

[Bill]

Hi Tony,
Sorry, I didn't explain myself very well. I have an application
where the VBA is running synchronous code (e.g., copy file)
where I want to broadcast to the user the progress of the
running process. My use of the word "mimic" was meant
to mean "I want to essentially do what Microsoft does when
it's uploading error information to their support site". I.e.,
tell the user what's happening as they await completion of
the process.
Bill

 

[Tony Toews]

Sorry, I didn't explain myself very well. I have an application
where the VBA is running synchronous code (e.g., copy file)
where I want to broadcast to the user the progress of the
running process. My use of the word "mimic" was meant
to mean "I want to essentially do what Microsoft does when
it's uploading error information to their support site". I.e.,
tell the user what's happening as they await completion of
the process.

Ah, gotcha. The problem is that the synchronous code has to allow
"call backs" to your code so that you can do something as it fires.
Some third party controls allow this. So it depends entirely on the
function.

I think I've seen some API calls that do this but I'd have to do a bit
of digging at vbnet.mvps.org to recall which ones do.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/