Search results

  1. MajP

    Need help turning a list into something form readable - training certifications

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

    Need help turning a list into something form readable - training certifications

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

    Need help turning a list into something form readable - training certifications

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

    Need help turning a list into something form readable - training certifications

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

    Yearly Attendance Tracker/Calendar

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

    Problem with 'Like' SQL filter

    Remove = " & "
  7. 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
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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?
  18. 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...
  19. 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...
  20. 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..)...
Back
Top Bottom