Search results

See this example of synchronized subforms. This is intuitive where you more than 2 levels Post in thread 'Sub Forms' https://www.access-programmers.co.uk/forums/threads/sub-forms.328859/post-1890497

You can nest subforms but I find them really hard to follow. If that was me I would have an unbound combo to select an account. This filters continous subform 1 with people in that account. I use conditional formatting to highlight the current row. Then I have contnous subform 2 which is the...

If I understand correctly, an account has many people and each person has many certs. If so you can design a form with subforms where you select an account and see the people in that account and see the current certs for the selected person. Depends on what you want to show. But you should be...

I will do it in pieces to make easier you could do this in two queries or even 1 if you are really good a sql. 1. query MaxCertDate SELECT trainingcerts.certname, trainingcerts.personname, Max(trainingcerts.DATE) AS MaxOfDate FROM trainingcerts GROUP BY trainingcerts.certname...

You can try PMing @oxicottin. I did the work on the calendar control, but he did the rest of the reports and subforms.

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