Recent content by dalski

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

This is more valuable than anything. Understanding best practices & the reasons behind them. Yes I'm most grateful. You've been a massive help yourself also. I received several solutions to my problem here but more importantly you've both helped me to grasp the concept of OOP, which I simply...