Search results

Of course, this is what RAM (Random Access Memory) is, & goes without saying for every application ever written. :ROFLMAO: :ROFLMAO: You're comparing apples with oranges, complete different topic in itself which results would be subject to how they were implemented. This thread's solution was...

In this case it was not about events, or forms. It was that Access protects wiping out user class-instantiation unnecessarily with this prompt; which is the same prompt as provided when code has not fully completed between called procedures. You're getting a little hung-up on standard Access...

Thanks, sorry I did not clarify in the OP I was talking handling user-declared bespoke Events with the Event-Handlers in different classes (not a basic Form Event like current) & we're a bit beyond instructions on how to set a breakpoint. The reference to Access objects was a very basic e.g. to...

Modern websites (last 20 years or so) use Cascading Stylesheets (CCS), & the media rule to test device size & apply appropriate designs for each/ type of device viewing/ processing the content. Think you can apply different stylesheets entirely.

Thanks, I think I muddied the waters a bit in post-01 with talk of user-declared events. Been using Access' standard events for sometime & fine with them. I am referring to user-declared classes & class-instantiations handling events raised from other classes... In Nr-12 commenting out all code...

Interestingly if I comment out all code in the problematic form I still get the error. Close the form, open another form (various) - no issues! Created a copy of the form. Commented out all code again. Still get the issue as if there is suspended code. But there cannot be. No other processes...

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...