word vba - VBA - Can I unload stack calls to avoid a runtime 28 "Out of stack space" error? -


i'm working on project uses vba userforms assist users in creating different word documents. 1 of requirements users able go , forth between userforms.

this latest document has more userforms (31 or so) previous ones, , i've found can trigger runtime error 28 "out of stack space" populating of forms, navigating first one, going forward again.

when going forward, i'm doing nothing different first time through, believe out of stack space due limit on number of calls, rather recursive or other problem listed in microsoft documentation here https://msdn.microsoft.com/en-us/library/aa264523(v=vs.60).aspx .

for record, unloading forms when going or forward. example:

private sub cb_back_click() 'backward navigation       unload me     showpreviousform   end sub

my question is, in vba there way can "unload" call stack?

it's extremely unlikely user did, i'm not concerned part of project, know in case other parts of project closer limit.

thanks in advance.

the way "unload" stack frame, return stack frame... or blow up.

i don't think unload me think does, , if does work intended, it's not going call stack.

the problem calling showpreviousform instead of returning caller: while "previous form" being displayed , until it's closed , execution runs end sub, call stack keeps track of position inside cb_back_click(), , until call stack unwinds, it'll stay right is.

you can observe behavior using call stack debug toolwindow.

there no programmatic way access call stack in vba. ever tried report stack trace error reporting wishes possible.

the solution not unload me , store state on form instance tells caller need go next; when end sub hit, caller can @ state value , determine do.


Comments

Post a Comment

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

python Tkinter Capturing keyboard events save as one single string -

is possible store keyboard events 1 string? code below stores 1 char , prints it. card reader or bar code reader, contains collection of character/ string not 1 character @ time. goal save char pressed text variable. from tkinter import * root = tk() def key(event): text= event.char text+= event.char print ("pressed", text) def callback(event): frame.focus_set() print ("clicked at", event.x, event.y) frame = frame(root, width=100, height=100) frame.bind("<key>", key) frame.bind("<button-1>", callback) frame.pack() root.mainloop() currently, creating text variable , everytime key() function gets called, , text stores last character typed. you can define text module level variable , , use module level text inside key function - text = '' def key(event): global text text+= event.char print("pressed", text)
Read more

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -

here tables: create table customer ( cid int primary key, name varchar(32) ) create table ord ( oid int primary key, cid int foreign key references customer, address varchar(20) ) here's linq-to-sql statement: var aaa = c in db.customer select new { c, o = c.ord.tolist() }; and here's inexplicable query generated linq-to-sql: select [t0].[cid] [cid], [t0].[name] [name], [t1].[oid] [oid], [t1].[cid] [cid2], [t1].[address] [address], (select count(*) [dbo].[ord] [t2] [t2].[cid] = [t0].[cid]) [value] [dbo].[customer] [t0] left outer join [dbo].[ord] [t1] on [t1].[cid] = [t0].[cid] order [t0].[cid], [t1].[oid] i want understand how rid of count(*) part. it's entirely uncalled for! linq needs count(*) in order determine number of entries returned o = c.ord.tolist() .
Read more