Recent content by MajP

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

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

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

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/

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

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

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