Recent content by MajP

  1. MajP

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

    Not sure I even get the crosstalk idea, unless you really want columns. Assume I have my qryCertDetails above. If I Cartesian join people to certs I get a query with all people and every cert. If I left join that query to qrycertdetails by person and cert. it will form a record for every person...
  2. MajP

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

    I agree I do not understand that either. EmployeeTable - EmployeeID - Employee Name -Other employee fields Certification Table - Certification ID - Certification Name - other Certification Fields Employee Cert Taken Table - EmployeeID_FK ' foreign key to employee table -CertificationID_FK '...
  3. MajP

    Solved Dblclick a command button?

    If they really wanted to do this put a timer on the second form load event and only enable the button after a set period of time. probably less that a half second. Works for me. Private Sub Form_Load() Me.btnContinue.Enabled = False Pause 0.5 Me.btnContinue.Enabled = True End Sub Public...
  4. MajP

    Best Practices for Optimizing Large Datasets in MS Access

    May want to look at https://support.microsoft.com/en-us/office/use-the-performance-analyzer-to-optimize-an-access-database-c44619df-4248-421f-9b8b-30b86082d792 http://allenbrowne.com/QueryPerfIssue.html If you really want to get into the details https://nolongerset.com/jetshowplan-a-primer/
  5. MajP

    Solved Dblclick a command button?

    Is this an academic exercise or the OP really wants to do this? Seems silly at best. The order of events is So if you double click you also click first. Here is my understanding why the command button has a double click. It is because it can be canceled and the click event cannot be...
  6. MajP

    Solved Dblclick a command button?

    not really sure I understand the issue that the user experiences but this may be an issue of the calling form or this form having a command button with default set to yes https://learn.microsoft.com/en-us/office/vba/api/access.commandbutton.default
  7. 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
  8. 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...
  9. 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...
  10. 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...
  11. 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.
  12. MajP

    Problem with 'Like' SQL filter

    Remove = " & "
  13. 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
  14. 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...
  15. 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...
Back
Top Bottom