What is ProcedureStack and where do I get it? ;)

[Rico]

Hi All,

I'm supporting an Access 2k database that has a line of code (from the
Access 97 developers handbook according to the comments) that has the line

"Public ProcedureStack As New ProcedureStack"

This line is causing an "User-defined type" error, BUT, I see no broken /
missing references and have no idea which reference to use. When I search
Microsoft Support on ProcedureSTack, I get "No Documents Found".

Any help would be appreciated, since I can't really compile this code
without it (and don't want to strip it out because of the consequences).

Thanks!

 

[Douglas J. Steele]

My copy of the ADH isn't handy, but it sounds as though there's a class
module you were supposed to import into your application.

 

[Rico]

Hi Doug,

That's what I thought. By the looks of the ADH items I googled, that's what
it looked like to me, but I couldn't find anything to download other than
the index for the CD.

I suppose I could comment it out and hope that it never gets used. From
what I can tell, it's only called out in one button of an "Error" form that
only gets called from one place.

Rick

 

[Clifford Bass]

Hi Rico,

I would agree with Douglas. It looks like a class. Probably supplied
on the CD that came with the book. I would guess that the class's purpose is
to record and provide the call/procedure stack manually since Access does not
seem to allow you to inspect it in its debugging tool. The call stack is
usually useful when debugging an error that crosses subroutine/function
boundaries. Therefore the reason for ProcedureStack being in a section
related to errors. So I think you are safe to get rid of it and just go with
any standard error handling. I sometimes mimic the presumed function of that
class by simply adding two Debug.Print lines to my subroutines that are in
question:

Public Sub SubroutineName

Debug.Print "Entering SubroutineName"

' The subroutines code

Debug.Print "Leaving SubroutineName"

End Sub

You then just look at the Immediate Window (VBA Editor, View menu,
Immediate Window item) to see the stack at the time of the error.

Clifford Bass

 

[Aaron_Lin]

Hi All,

I'm supporting an Access 2k database that has a line of code (from the
Access 97 developers handbook according to the comments) that has the line

"Public ProcedureStack As New ProcedureStack"

This line is causing an "User-defined type" error, BUT, I see no broken /
missing references and have no idea which reference to use. When I search
Microsoft Support on ProcedureSTack, I get "No Documents Found".

Any help would be appreciated, since I can't really compile this code
without it (and don't want to strip it out because of the consequences).

Thanks!

OK! sorry!!!