Search results

I have a few events firing & yes the load event is the first that kicks things off. Tracing through them I cannot see any 'suspended' code relating to the events/ code in question. Appreciate I might be a bit cavalier/ wrong here; but I have cautiously watched the calls & sequentially terminate...

To clarify I do not get the error outside of the form/ sub-form in question; from starting up normally or from shift-bypass. All other areas are fine. The process is only running because I loaded the form after loading up from shift-bypass; alas I get the error.

Thanks, I still get the error.

Sorry - if I create a new sub/ function from the problematic form/ sub-form I will get the prompt indicating some code is 'suspended/ running'. If I create a new sub/ function I do not get this prompt.

When I go to debug I'm getting "This action will reset your project, proceed anyway?". The problem occurs in a certain sub-form, with classes & user-declared events... My code is running fine, but this does not seem good practice; or am i being pedantic? I've stepped through code looking at the...

What book Pat? Nearly finished my second book on Access - MS Access Programming Inside Out. Very good but the section on classes could have had better examples IMHO.

Thanks @jwcolby54, trying to get my head around this atm. Couple of links to help others in the future, which you've pretty much explained in OP. https://nolongerset.com/circular-references/ https://nolongerset.com/memory-management-in-vba/ - Memory Addresses

Sounds like Sharepoint can handle Access' Transfer Connection Protocols (if that's the right term). Whereas OneDrive/ Nested Shared Folder cannot. I was not aware of this - thanks.

So the second shared folder avoids the OP from having to keep his computer on for other users to be able to access?

Sorry I see you put that. Ok you said a Compact & Repair worked fine & it decompiles without problem (excluding "Public gbDebug As Boolean" in the standard module modVariabiliGlobali. For the crack create a new blank db & import everything Ribbon > External Data, New Data Source > From Database...

It will run because the point of Option Explicit is it checks for undeclared variables. You've stored them in a standard module right? Not in a Form module or class module. Declared in the header & not between procedures...

I know nothing so bear with - I hear few suggestions these days relating to Access & MySQL. One usually only hears of Access & MSSQL & I wonder why that is? I've used systems that use MSSQL with a local installation at the business feeding circa 15 users & it has been good, about + 1/2 slower...

That's what had me fascinated & what I attempted earlier with Me.FunctionName() executed from the form. Shockingly so, dumbfounded it is not a dynamic reference :eek: . I'm referring to below where 'Allows consumer to modify obj's properties. Set AddBtn = lBtn. Sure accessing a class'...

Thanks Mark Memory Leak I'm experiencing a memory leak between cPopup & cPopupBtn; each use of the right-click the code loops between the cPopupBtn & cPopup +1 more increment. Either instance is not being destroyed/ btns collection. I cannot see where I'm differing from your code apart from the...

Thanks Pete, my main goal is to avoid public declaration & encapsulate the function within a class/ form. Typical, spent about 50 hours going through it & find a solution several minutes after posting. Honestly no exaggeration here. I was fixated on the .OnAction property of the button, as it...

I wonder if it is ADO procedure. The rs is declared as 'Data Access Object'; so not ADO. But ADO used to be the default format for Access, then they changed it to DAO as the default. It's best to explicitly declare the type; as you have done. There are differences between the two, different...

Sorry to bump thread, anyone have a solution to this? Lost nearly a week on it full-time. I've stepped through Mark's code too many times to count. Using Mark's fine code I still get the same error. I cannot gain access to a function assigned to the .OnAction property of the cPopUpBtn from the...

Thanks Mark, it's very nice & I spent over an entire weekend playing with it. But my clsBillOrPage is intrinsic to the form & more so my main endeavour is to use the .OnAction property to run different functions; which the entire purpose of classes is to contain what is relevant to that class...

Thanks for the rapid response guys, massively appreciated.

I have a class for a Subform; trying to encapsulate all relevant things. The MouseUp event (assigned to the class) deletes & builds a relevant right-click context menu. But if I place a Public Function InsertPageFromABill() within the class to handle a button in the Command Bar it is not visible...