I have an Access 2003 front end connected to an Oracle back end
database. Much of the usage is ad-hoc and I need a way to show the user
the length of time it took to complete the last query run. (Some
queries are nested of course.)
Is there a way of showing a simple: "Procedure finished in 3min45sec or
even 3:45" in the message bar at the bottom? Or perhaps a small applet
window in the corner? I'm not sure what the most effective way to
display it is yet, but I know I need to display and log the info.
Anyone have any ideas? Could I somehow set a module or procedure to at
the beginning of each procedure involving queries save the begin time,
then at the completion of the procedure save the end time and then
subtract one from the other and show it in a non-intrusive spot?
Thanks in advance,
JN