Is there any way of determining in VBA the name and arguments of the
currently executed procedure?
To assist in debugging, I would like to be able to trace the procedures as
they are executed. Then, when it crashes with Access's usual unhelpful
error messages, at least I will be able to determine in which procedure it
happened.
What I had in mind was something like this, inserted as the first statement
in every procedure during development:
If DebugMode Then
<extract required information about procedure>
Debug.Print <procedurename, arguments>
End If
Of course one solution would be to tailor the above by manually inserting
the procedure and argument information in each case, but with a large
project this would be quite tedious. I would rather have some standard code
that I can just drop in to each procedure as I go.
Do procedures have properties (as do forms, controls, etc)? Is there a way
to determine the current procedure (similar to the "Me" for the current
form)? I have found nothing in the Help manual or in various other
resources, so I suspect that there is nothing like this. But the experts
very likely have some sneaky way to accomplish this!
TIA for any help.
--
Cheers,
Lyn.
