[AccessD] Out of stack space

John - I'll bet that's it, I put in a requery for the form so I could update
a text box (to increase the database version number) with the press of a
button, and I put it in the wrong place.  Now it seems to be okay.  I guess
it was just coincidence that I made the change at a time when it would make
it appear to be related to the Windows or Office versions.

Thanks Brian and Bobby for your replies also. 

Nancy Lytle
EIS
nancy.lytle at auatac.com
202-314-1393


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby
Sent: Wednesday, October 29, 2003 10:34 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Out of stack space


Out of stack space usually means a recursive call that isn't ever backing
out, i.e. just recursing continuously until all memory is used.

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Nancy Lytle
Sent: Wednesday, October 29, 2003 9:58 AM
To: Accessd
Subject: [AccessD] Out of stack space


I just got Windows XP and Office XP loaded at work.  Now when I call my
function to grab the user name I get an "out of stack space" error.

>>>>>>>>>>>>>>>>>>>>>>
Here is the function code:
Public Function fcnOSUserName() As String
On Error GoTo Err_fcnOSUserName

    'Returns the network login name from the Operating System
    Dim lngLen As Long, lngX As Long
    Dim strUserName As String
        strUserName = String$(254, 0)
        lngLen = 255
        lngX = apiGetUserName(strUserName, lngLen)
        If lngX <> 0 Then
            fcnOSUserName = Left$(strUserName, lngLen - 1)
        Else
            fcnOSUserName = vbNullString
        End If
Exit_fcnOSUserName:
Exit Function

Err_fcnOSUserName:

Call LogError(Err.Number, Err.Description, "fcnOSUserName()")
    Resume Exit_fcnOSUserName
End Function
>>>>>>>>>>>>>>>>>>>>>>>>>>>

It still logs in the user name to my userlog table but I'd like to get rid
of the error since it stops the program and asks if you want to end or
debug.  My users would freak out if they saw this.

Anyone know what's going on?

Nancy Lytle
EIS
nancy.lytle at auatac.com
202-314-1393

_______________________________________________
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