Search results

Remove = " & "

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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