Search results

  1. MajP

    Problem with 'Like' SQL filter

    Remove = " & "
  2. MajP

    Solved searching with a partial string

    You may be Interested in https://www.access-programmers.co.uk/forums/threads/like-function.319388/post-1784109
  3. MajP

    Solved searching with a partial string

    I think, if I was doing a huge clean up I would pick one of those algorithms like simil. Then loop all your records and return and save all like values that meet a certain score. Maybe anything above a .65 if using Simil or 70 using Leven... These are then "pretty similar" records. Or maybe...
  4. MajP

    OpenArgs (my) class way

    I think you might be reading to much tone that is not intended. That was not meant to sound superior in any way. It is clearly not a criticism and specifically reiterated that more understanding of debugging is good and not understood by many. But I truly do not understand how you would use...
  5. MajP

    Solved searching with a partial string

    In that example there are 10k names in the list. You can play with the Find as You type and that would instantly find your example above. But the more challenging ones are when you know it something like "Cathy " or "Kathy" or "Cathy, Kathy, Cathie, Kathie, Catherine, Katherine ...." That is...
  6. MajP

    Solved searching with a partial string

    I have a couple demos using different techniques. You can use soundex that allows you to search things that sound alike But in the demo I found that a Find as you type is really the fastest way. If I type Dr it finds anything with DR if I add DRY then it finds anything with DRY See these...
  7. MajP

    Solved A Really Simple Question

    @Edgar_ I think you and @Pat Hartman disagreeing on different things. I do not think Pat would have any argument about a read only unbound form in single form view (maybe I am wrong). Sure that is quick and easy and is a valid choice for an unbound form. But like her that is not what I see...
  8. MajP

    OpenArgs (my) class way

    I do not get it. This is standard debugging, and yes many people are not well versed in that. But this seems irrelevant to the conversation of when you "need" to set an object to nothing. Or at least I am not seeing how this would be used. Lets say I want to do a test which I do not think the...
  9. MajP

    Help On Locating Text by Position (Fake Treeview)

    If you look at the indented form below the tree view in this post https://www.access-programmers.co.uk/forums/threads/nested-headers-nested-subqueries-normalization-correct.333887/post-1961214 I do some indenting that makes it look "tree ish" As I say in that post somewhere I have to write to a...
  10. MajP

    OpenArgs (my) class way

    @Edgar_ I would say I am pretty savvy with debugging, but I have no idea how I would use this to determine if I need to set an object to nothing. Are you saying it can point out circular references? Is this available in standard IDE or something like MZ-tools? I have MZtools and used...
  11. MajP

    Help On Locating Text by Position (Fake Treeview)

    I did not go any further with my version, but @CJ_London pointed out several possible enhancements. If you know the upper most levels (which you often do) then by storing the relation at all levels you can speed up the expanding and collapsing. Using the same idea but using a continuous form...
  12. MajP

    Form seems to have table locked even after closing.

    What is that? Is that your add-in or someone else's add in? Or is that outside of Access?
  13. MajP

    OpenArgs (my) class way

    Is there any place I say I have a problem with setting an object variable to nothing? I do not think I suggested that people should not do this. I am not criticizing you for doing it. Again, I say it every time. If globally doing this makes you feel better than have at it. But I have issue...
  14. MajP

    Form seems to have table locked even after closing.

    @Papa_Bear1 I agree with others that this design might not be the best, but understanding the problem regardless is important. So when you close all forms / subforms connected to a table "closed is closed". And this should work. There may be a timing issue. Without seeing your code you may be...
  15. MajP

    Wrapping controls WithEvents in classes

    Actually I did have it correct, as @cheekybuddha said, it does say that quote in the last line of the song. Not that there was any "je ne sais quoi" thought put to this, I just copied something from the internet (top ten famous quotes from..)...
  16. MajP

    OpenArgs (my) class way

    Sorry if my rant seemed directed to you, it was not meant to be. It really to all the other people that repeat this information and state that setting objects to nothing is a requirement and the the solution for all our coding ills. Trust me you will see it on this site often. As I said if...
  17. MajP

    Form seems to have table locked even after closing.

    From what you were saying my assumption was the form was closed and all connection to the table were closed. This may not have been a good assumption. But assuming it was true, that was why I was suggesting it could be corruption. However although @isladogs did not chime in he does have a...
  18. MajP

    Form seems to have table locked even after closing.

    To me that sounds like some form of curruption. Compact and repair is unlikely to help but worth trying I would try a decompile and recompile and see if that helps https://www.fmsinc.com/MicrosoftAccess/Performance/Decompile.asp May also want to create a blank db then reimport in all the...
  19. MajP

    Wrapping controls WithEvents in classes

    There is even a song to go with it. But I realize now I typed the quote wrong and should read "I've got mine" And yes as @NauticalGent pointed out, super creepy and disturbing.
  20. MajP

    OpenArgs (my) class way

    No you do not. You do not destroy anything. All you are doing is releasing a pointer. But if this makes you feel better continuing doing it. If you believe that VBA does not have a trusted clean up, I say prove it. All this discussion about setting objects to Nothing is usually a complete...
Back
Top Bottom