Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 07-05-2009
Member
 
Join Date: Jan 2009
Posts: 110
Runtime error "Out of Stack Space"

I am facing an issue whenever i am trying to click on Open or double click on any record i am getting the following error message

Runtime error "Out of Stack Space"

I don't know whats wrong with it early i never got this message and for more information i am using Access 2007 and DAO method.
Reply With Quote
  #2  
Old 07-05-2009
Member
 
Join Date: Jan 2009
Posts: 150
Re: Runtime error "Out of Stack Space"

It might happen that you have too many active Function, Sub, or Property procedure calls because of that you are getting this error message or check that procedures aren't nested too deeply. This is especially true with recursive procedures, that is, procedures that call themselves. Make sure recursive procedures terminate properly. Use the Calls dialog box to view which procedures are active.
Reply With Quote
  #3  
Old 07-05-2009
Member
 
Join Date: Jan 2009
Posts: 110
Re: Runtime error "Out of Stack Space"

I had a check for it everything is proper but i don't know why i am getting getting Out of Stack Space error message you can also have a check for the code might i have made any mistake

Code:
Private Sub SearchList_Data1Click(Cancel As Integer)
On Error GoTo Err_SearchList_DblClick
Dim Data1 As DAO.Database
Dim CN As DAO.Recordset

DoCmd.OpenForm "FrmProducts"

Set CN = Forms!FrmProducts.Recordset.Clone

CN.FindFirst "[ProductID] = " & Me.SearchList
Forms!FrmProducts.Bookmark = CN.Bookmark

DoCmd.Close acForm, Me.Name

Exit_SearchList_Data1lClick:
Exit Sub

Err_SearchList_Data1lClick:
MsgBox Err.Description
Resume Exit_SearchList_Data1lClick
End Sub
Reply With Quote
  #4  
Old 07-05-2009
Member
 
Join Date: Jan 2009
Posts: 150
Re: Runtime error "Out of Stack Space"

As i can see in your code you have to replace the following code from

Code:
Set CN= Forms!FrmProducts.Recordset.Clone
to
Code:
Set CN = Forms!FrmProducts.Recordsetclone
because you are using DAO method not ADO method and i hope now you won't get Out of Stack Space error message.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Runtime error "Out of Stack Space""
Thread Thread Starter Forum Replies Last Post
Getting error message "unable to find a version of the runtime to run this application" Rounder1 Operating Systems 2 07-01-2012 11:50 AM
Just in time Bugging [An Exception "Runtime error" has occurred in Script] Glinda Technology & Internet 4 05-04-2011 03:27 AM
Runtime Error "13": type incompatible Shell Operating Systems 3 14-06-2009 05:21 AM
Keep getting error: "Microsoft visual basic c++ runtime library" Maff Vista Help 8 13-01-2008 02:18 AM


All times are GMT +5.5. The time now is 05:02 AM.