Who called this sub or function? 
Author Message
 Who called this sub or function?

In Access97, I have a few procedures that can be called by a
number of places in the program. They could be called from forms,
reports, or other procedures, or even macros.

Is there a way, in code, to tell where they were called from?

Thanks,

Norm



Tue, 26 Apr 2005 07:57:03 GMT  
 Who called this sub or function?
Hi,
You can build something like that into your functions.
Just add an argument that will indicate where it was called from.

HTH
Dan Artuso, MVP


Quote:
> In Access97, I have a few procedures that can be called by a
> number of places in the program. They could be called from forms,
> reports, or other procedures, or even macros.

> Is there a way, in code, to tell where they were called from?

> Thanks,

> Norm



Tue, 26 Apr 2005 09:51:45 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Calling a sub or function using a variable through another sub or function

2. Calling a sub or function

3. How can I Call a Sub or Function Procedure with a Variable as Function or Procedure Name. Please Help

4. Returning sub or function name within a specific sub or function

5. Local function/sub inside function/sub

6. Exit Sub from called Function

7. Finding called Sub and Functions in code.

8. Calling Sub or Function in another copy of the CURRENT database

9. Calling functions/subs using the string title - possible?

10. Calling a function or sub in Excel from Access

11. Calling function/subs from other databases

12. Calling a Word97 VBA function or sub from MSAccess97

 

 
Powered by phpBB® Forum Software