Search results

Very interesting and almost there :oops: A few points on the queries you very kindly setup in my db: qryDueMandatoryTraining shows a false record i.e., 2nd from bottom. If you look in EmployeeXCourse_JT McNeill hasn't yet completed the training B1 Counterbalance. The completed date access shows...

Based on the actual data in the attached db, I would like to show, for each employee, mandatory trainings as follows: EmployeeID CourseID CertificationDate ValidFor ExpiresOn 14 15 02/03/2023 1825 29/02/2028 14 36 36500 14 30 222 17 15 1825 18 37 04/03/2023 1095 03/03/2026...

Hi again As some of you already know I am working on building an employee training record db. I have become stuck at one issue in this db which I believe is down to how I have structured my data. The main functionality that I am looking out of it is to keep record of trainings employees have...

Re points: 7. I only put them in place to initially help me understand the links I was making better, however, I have removed the table level lookups completely now 6. Same for MVF. I have replaced it with a subform 5. I saw the Bad Data video 1 (couldn't find the second part) and I am going to...

Oh, I am not offended at the feedback at all. Apologies if I came across that way. It was meant to be a light-hearted comment :D I am fully aware that my db was not upto the mark, hence my admission that I was reluctant to share it in the first place. However, every single reply and suggestion...

Hi all I have taken some thrashing from the experienced db programmers over the weekend 😟 In my defense, this is the first database I am developing andI'm building it as I learn from various resources. Reason I have not used BeforeUpdate anywhere in the db is because I have not seen anyone use...

Please find the db attached. I was reluctant more because it may be a mess. But at the moment, I just need the subforms to work. Thanks for your time, really.

I am sorry to bother you again, but issue I am facing with subform now is that I cannot add new record within the subform. When I open the subform individually, I can add records. Please see attached images. Capture1 is standalone form, Capture2 is embedded in the main form.

My bad, apologies. I assigned the EmployeeID in OpenArgs, however, now when I click on new record, the textbox field says #Error Note: As Josef P said, it is easier with the subform so I am doing that way, however, extra knowledge can never harm, so I appreciate your response very much.

I'm sorry I don't follow. I thought that's what should happen, where every new record on a junction table has its own new ID?

I might just go with subform then. Just for my own curiosity, how would you bound a text box to the EmployeeID of the current record on the main form?

Yep. the junction table's own PK is called ID, whereas EmployeeID and CourseID are FKs

Hi both It is not a subform. Its a separate form which using a command button (using docmd.openform). The separate form is based on a junction table, which links EmployeeID to CourseID). Reason I have not put it as a subform is because I have other forms linking to the main form, all of which I...

This is exactly I had it setup. And that's how I had entered previous data but now for some reason, that link is gone. I can now only save new courses but access does not save the employeeID connection.

Hi all I have a training database where on the employee form, I have a command button which takes me to another form i.e., Training Records. I have a junction table with EmployeeID and CourseID (PK for this junction table is simply called ID). Issue I am having is that any new data I try and...