Search results

  1. jwcolby54

    Form seems to have table locked even after closing.

    It never occurred to me to just find a property somewhere to set it. That is pretty cool!
  2. jwcolby54

    Form seems to have table locked even after closing.

    Is the form bound to the table? Is the form actually closing? Is it the subform's table that you are trying to delete? As @isladogs pointed out, the subform closes after the main form so if the subform is bound to the table, the main form can't delete the table because the subform is still...
  3. jwcolby54

    The Garbage collector in VBA

    Hmmm, trying to figure out how I could do something like this. For example an app using my framework loads a form. That kicks off an entire process. clsFrm loads, the control scanner runs, finding all of the controls that my framework wants to deal with - combo boxes, text boxes, tab...
  4. jwcolby54

    The Garbage collector in VBA

    Do us a favor and at the very bottom put a little "actionable items" piece. What if anything can we do to reduce the problems you experiences.
  5. jwcolby54

    The Garbage collector in VBA

    @The_Doc_Man ... Even my eyes are crossing. You (and I to a lesser extent) are steeped in the actual hardware behind the scenes. I understand stacks and stack pointers, and heaps, FIFO, LIFO and all that jazz. That is all pretty esoteric to today's developers. Or at least Access developers...
  6. jwcolby54

    OpenArgs (my) class way

    The thread on "garbage collection on VBA" is up there now.
  7. jwcolby54

    OpenArgs (my) class way

    I am setting up a discussion on how VBA's garbage collection works. Is it a "garbage collector"? Who really cares. What does that really mean? Such an existential discussion we launch into. In the end it takes care of releasing the memory used for our objects when we release them. The...
  8. jwcolby54

    OpenArgs (my) class way

    533 views as of this instant. But hey. I have no metrics to tell me how many of those views are novices etc, or who follows things. And you are right I am no teacher. I have answered you same "issue" over and over and you either don't understand or choose not to understand. In the end I am...
  9. jwcolby54

    OpenArgs (my) class way

    Now do me a favor and (since you are such a great instructor) tell me how to ignore your posts?
  10. jwcolby54

    OpenArgs (my) class way

    Funny you should mention that. I understand "last pointer" thing but IMO the vast majority of devs do not. The man asked a simple question, I gave a simple answer. I am (or more correctly was) deep into classes and frameworks, where objects loaded other objects, kept pointers to forms, passed...
  11. jwcolby54

    OpenArgs (my) class way

    LOL, it is not my job to provide any reason for you to invest the time to use it. We all tread the path we tread on this earth. I have explained in some detail what a framework is, what mine does, and how this specific tiny little part of my framework contributes to the whole. You apparently...
  12. jwcolby54

    The Garbage collector in VBA

    I had a poster in one of my threads post that if I did some thing his way it would avoid a circular reference, and how circular references could cause memory leaks (true) and how if Access crashed the end of the (access) world could commence. Not so true but worth dealing with. The point...
  13. jwcolby54

    Wrapping controls WithEvents in classes

    Interesting. I was on a zoom last night over at Access Pacific group and I was asking about this subject, specifically because there have been complaints or mutterings that my links weren't working. So we were testing. I use firefox and when I open the pdf for the book it happens more or less...
  14. jwcolby54

    Wrapping controls WithEvents in classes

    @MajP I chuckle at your signature every time I read it. It does leave in question whether "your things" are a cut or more above good (my impression), or below good.:ROFLMAO:
  15. jwcolby54

    Wrapping controls WithEvents in classes

    Another thing I discovered in the zoom call tonight is that the links I am creating to files out in GitHub are not what I thought. The book PDF is being opened directly in a browser directly in the GitHub repository. If a reader wants it on their computer they have to do a download manually...
  16. jwcolby54

    Wrapping controls WithEvents in classes

    I learned a lot tonight. I did a presentation on C2DbProperties on Access Pacific zoom call. The devs on that zoom are first rate and we had a brisk discussion about a lot of different stuff including GitHub and Git. I have been writing my book EventDrivenProgrammingInVBA in LibreOffice...
  17. jwcolby54

    OpenArgs (my) class way

    The safest is to iterate the collection and delete each item. However I believe that just destroying the pointer to the collection will cause the garbage collector to clean it all up. At one time I had a function I could call, passing in a collection, and it wold do that iterate / delete each...
  18. jwcolby54

    OpenArgs (my) class way

    My framework enables behaviors across my entire application. A clsCtlCbo is loaded anytime that a combo is encountered in any form where clsFrm is being used. So... clsFrm calls its control scanner function to scan for controls. The clsCtlCbo is instantiated automagically. A pointer to that...
  19. jwcolby54

    OpenArgs (my) class way

    My apologies. I don't use the insanely useful scripting runtime. As such I don't pay much attention. From No Longer Set - vbscript deprecation From the often wildly inaccurate ChatGPT: Yes, Microsoft has announced plans to deprecate VBScript, which includes the Microsoft Scripting Runtime...
  20. jwcolby54

    OpenArgs (my) class way

    Well. My feelings are all properly mended now! :) :D :cool:
Back
Top Bottom