[AccessD] Call Stack in VBA?

Shamil Salakhetdinov shamil at smsconsulting.spb.ru
Fri Jul 25 12:40:22 CDT 2008


Hi All,

In fact I have got developed almost 10 years ago such a callstack
tracing/profiling simulation code together with a utility code to
inject/remove tracing/profiling code in all and every function/sub of an MS
Access or VB6 project (FYI: this tracing/profiling code DOES put in the call
stack the parameters values/refs )...

I did use it several times to find not easy to capture bugs but that's it...

And I wonder is there a real need in such a tool for everyday VBA/VB6
development? Probably not, otherwise MS or some third-party company would
develop such a tool for sure - MS-Tools doesn't have such a tool?

I mean will it be worth to find this code still I hope "buried" (i.e. not
yet annihilated) somewhere in my archives and make an add-in, which will be
useful and used at least one time but to solve important real life
development task by at least 100 (one hundred) developers from all the world
community of MS Access developers? 

I mean I have no any plans to make such an add-in a commercial product
because I do not believe in its commercial success but I can try to make it
wrapped-out into a useful freeware add-in, and to do that I'd need to spend
some of my time and if such an add-in is not needed to at least 100
developers then it's probably not worth to spend time on making it wrapped
into an add-in and published...

What is your opinion?

Thank you.

--
Shamil

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Thursday, July 24, 2008 11:48 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Call Stack in VBA?

For hundreds of procedures, that would cost me a lot of time.

But for troubleshooting, this could be priceless!!  ;-)

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Thursday, July 24, 2008 1:10 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Call Stack in VBA?

I don't know how fruitful this will be without access to the call stack.
It's simple enough to write a stack class. A stack is a simple array plus
two operations -- push and pop. But without access to the Access call stack,
you'll have to insert some code into each procedure that pushes the proc
name to the stack. That's a lot of work.
Arthur

On Thu, Jul 24, 2008 at 1:15 PM, Dan Waters <dwaters at usinternet.com> wrote:

> Thanks Charlotte - I just checked the archives for clsStack, but no
results
> came back.
>
> Do you have more information about what Lambert posted?
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list