"Out of stack space"

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

Been working in my growing Access db today and a problem has cropped up.

On a form I have a combo box and 'after update' another form is opened using the ID from the combobox selection. For no apparent reason, I will get the following error as the next form begins to open.

Run-time error '28':

Out of stack space

If I choose 'End', the Access app just closes immediately. I've checked in Windows Task Manager and neither the Access application or its process is active.

If I choose 'Debug', the following vba, which is on the opening form, is highlighted

txtDate.Value=Format(Now(), "mm/dd/yy" & " " & "hh:mm am/pm")

If I choose 'Reset' in the VBA editor, the Access app closes immediately.

Any ideas. I've looked in MSDN and don't see a good lead to pursue.
 
Never mind, I think I found the problem.

I was reworking a main form that had a subform on it. The subform had become a pretty archaic idea so I was slowly copying a control from the subform to the main form and then copying the VBA behind it and testing each control. That meant that I had a cboBusiness on a main form's subform and also on the Main form.

I'm not sure that was the problem but I convinced myself that it was so I've now deleted the subform altogether and the db hasn't thrown the run-time error since(knock on wood).

Karen
Been working in my growing Access db today and a problem has cropped up.

On a form I have a combo box and 'after update' another form is opened using the ID from the combobox selection. For no apparent reason, I will get the following error as the next form begins to open.

Run-time error '28':

Out of stack space

If I choose 'End', the Access app just closes immediately. I've checked in Windows Task Manager and neither the Access application or its process is active.

If I choose 'Debug', the following vba, which is on the opening form, is highlighted

txtDate.Value=Format(Now(), "mm/dd/yy" & " " & "hh:mm am/pm")

If I choose 'Reset' in the VBA editor, the Access app closes immediately.

Any ideas. I've looked in MSDN and don't see a good lead to pursue.
 
Hi Karen,

Thanks for your post. According to your description, I understand that you
get the following error when you open a form:.

"Run-time error '28':
Out of stack space"

If I have misunderstood, please feel free to let me know.

This error message means that there are too many items stored on the
program's thread, which has limited space. One possible cause of this is
due to recursive calls. Other most probable causes include passing arrays
or big size user defined types through parameters. Based on current
information, it is hard to narrow down this problem. Can you please provide
me with more information so that I can perform further research?

1. What is the version of Access you use?
2. Does the problem only occur sporadically, or does it always occur?
3. Please provide the detailed reproduce steps so that I can try to
reproduce this problem on my side.

Also, please perform the following suggestions in your Access application.

1. Modify your code in the following manner... whenever any object is
opened, make sure it is then closed and destroyed
e.g.
rs.close
set rs = nothing

2. Please make sure that the query name and the table name in the query are
not the same.

3. Review the following article to see if the reserved words are used
correctly:
ACC2002: Reserved Words in Microsoft Access
http://support.microsoft.com/support/kb/articles/q286/3/35.asp

Thanks for posting to the community.

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
 
Hi Michael,

You'll see by other post that I though I had the problem fixed but it did
happen one time today so..........

I am using Access 2003 but the specific database is Access 2000 format.
The problem was all the time yesterday when I did the steps I outlined but
today just once.
I detailed the steps I took in my first post
"
On a form I have a combo box and 'after update' another form is opened
using the ID from the combobox selection. For no apparent reason, I will
get the following error as the next form begins to open.

Run-time error '28':

Out of stack space

If I choose 'End', the Access app just closes immediately. I've checked in
Windows Task Manager and neither the Access application or its process is
active.

If I choose 'Debug', the following vba, which is on the opening form, is
highlighted

txtDate.Value=Format(Now(), "mm/dd/yy" & " " & "hh:mm am/pm")

If I choose 'Reset' in the VBA editor, the Access app closes immediately"

Unfortunately, I think it is probably impossible to duplicate the problem
unless you have my database which has the problem.

I have checked all objects and I think I've closed them.

I don't think there is anything to pursue at this time but I appreciated
your remarks very much.

Karen
 
Hi Karen,

Thanks your update. Yes, you are correct that there is not an easy way to
detailed reproduce and narrow down the problem without the original
problematic database. Due to the feature of this issue, it would be best to
contact Microsoft Product Support Services via telephone so that a
dedicated Support Professional can assist with your request. To obtain the
phone numbers for specific technology request please take a look at the web
site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

Thanks for posting in community.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
 
Back
Top