Search results

Ok guys, I finally got some time to attempt this. Attached are two pics for my SQL statements. I didn't know if attaching a Word document is allowed on this site. One attachment is the long version & the other is the shorter version. I'm pretty new at writing SQL, hence the reason why I...

I'll take this into consideration when I try something tomorrow. I'll let you know how it turns out.

Thanks Plog. I wanted to update this thread so that you guys don't think I just bailed. I'm going to try something tomorrow. It totally makes sense what you're saying. Hopefully I can get somewhere by combining the WHERE clauses.

I tried overwrite my previous union query with the updated, longer union query & the attached file is the error message I got. I'll have to look up how exactly my subqueries would look like in code. I don't know if I should go this route or the multi-value table route, but this seems more up...

To be honest, I was following this guy's example: https://www.youtube.com/watch?v=-tUMfbsJVTA&list=PL3E83E94F90BA0F44&index=8 I'll have to do some tinkering to see if I can get the multi-value tables to work.

Sorry; I was gone from work for a few days. There are 22 items for each employee. Of those 22 items, two of them are renewed every two years; the rest are renewed every year. I would love to default them all to one year but I can't because of this. Also, it's not that the items aren't...

Apparently, I've hit a 255 character limit with my previous union queries. So my next thought was to break up the union queries into smaller chunks & have an option group invoke a specific query which is also filtered by the EmpID field on the same form. Here's what I mean: the...

Hi Gemma, Thanks so much for the reply. What I didn't provide was the list of union queries. In each union query, the training modules (items) are in fact dependent on the work area (unit). For example, people are trained on chest tubes yearly on one unit but may be done every two years on...

If it's only supposed to update one record at a time in the junction table, then I suspect an update query is the solution to update many records belonging to the same employee? My concern is, "What if my employee changes work areas (units) & now needs all of his/her records to reflect the new...

The following attachments should make it easier to understand my problem: 1. My relationships 2. tblUnits where I want to get the fields from 3. My form where I want to place that field 4. Junction table to show the structure of the data input As mentioned, I've created the combo box before in...

Thank you for your response. I know this forum is staffed by volunteers; this isn't my first post on this site. I've been very informative before & the info has proved helpful to others in understanding my problems. I'll post some screenshots shortly.

I haven't been able to find a non-VBA solution to this problem, but here we go... There's an employee form that has the person's name & some other info. Within this form is a subform with the training modules the employee has completed & their dates. The main form's & subform's data properties...

Thanks a bunch for solving my problem man. I appreciate the help.

Ah ha! That was part of my mistake. So including the "Is Null" statements just displays everything on the form with no selections it seems like. I actually preferred the form to preload totally blank so I took out the Null statements altogether. I could've sworn I tried this method before with...

I realize that once the form is filtered according to work area, the user can then just right-click on a training module & choose the "Equals to" option. That's great but I wish to make a combo box for that too.

Sorry; I had to take a break. Tried it. Put the appropriate criteria line in the query but it still only filters the form once (per the work area) & not also by the training module. At first I thought maybe the me.requery code had to be written for the second combo box, which I did, but it still...

Just a few more humps to get over... Only using one line of VBA (which I don't know), I was able to accomplish the following: -Built a form based on a junction table which contains employees, the work areas they're assigned to, the training modules they've completed, & the completion dates for...

Yeah, I agree that this is difficult to do. If they were doing this in Excel, I'd imagine they would have to scroll down to everyone that showed up & manually type in the new completion date. I was thinking of making a continuous data entry form for this purpose, but I just don't want all of...

Thank you for the reply. My database is tracking compliance with training modules for various employees (94 people at the moment). Some of those 94 belong to different work areas in a hospital. Perhaps one day, work area A wants to retrain everyone on how to perform CPR, except that not...

Hello, Without VBA (if possible) I want to achieve the following for my end users: Give them the ability to update only some of the records in a table. For example, a workplace with 50 employees, in which they only want to update 25 people at one given time or something like that. Later on...