Dan Waters
dwaters at usinternet.com
Fri Jul 25 13:38:51 CDT 2008
Hi Shamir! I was wondering if this particular thread might capture your attention! This would be quite valuable to me. I have several customers who use my system. Part of the system, a library file, is identical at each customer. Almost all procedures contain error-trapping, which usually gives me enough information to solve a problem. But occasionally, an error has gone through several procedures before it gets error trapped, and the information I can capture just isn't enough. Of course in a situation like this, I often can't duplicate the problem. In this situation I have to start guessing, and rewriting code to start passing information from procedure to procedure, which is time consuming and often not successful anyway. If you have raw code, I would be willing to try to use that. As for 100 developers world wide who would want this, I'm sure they exist. Two of them are here - me and Arthur! But for the rest, there would need to be a way to advertise it's existence. Does anyone know of a good place to advertise or look for good Access utilities and add-in's? Thanks! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil Salakhetdinov Sent: Friday, July 25, 2008 12:40 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Call Stack in VBA? 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com