Search results

I agree that that's better practice. No question about it. But for right now, I need to solve this query problem before making any changes to the data model, or lack thereof. I ran the SQL statement mentioned above for #3 and got the following results: Jane,1,Fulbright Jane,1,Nobel...

Currently, I only have one table and I don't want to change the structure of the database unless it's the only way to do this count. I tried to follow your instructions for #3 but could get it to do what I needed.

I managed to do #1 and #2. But I can't get the first part of #3. It doesn't aggregated when I filter on 'Nobel' Or 'Fulbright'. I get: Jane,1,Fulbright Jane,1,Nobel John,1,Nobel Michael,1,Fulbright. I can't get it to aggregate Jane,2.

Yes, that would be helpful, but at this point I can't redesign the database. I only have one table.

Thank you. I am new to SQL. Could you please give some examples? Note that I only have one table: tblEmployeeAwards. I don't have a tblEmployee.

I have a table that contains names of employees and the name of awards they received. tblEmployeeAwards EmployeeName, AwardName John,Nobel John, Pulitzer Michael, Fulbright Jane, Nobel Jane, Fulbright I would like to know the following: 1. How many employees received more than one award...

I am aware of the Outlook.Application functionality. Can VBA in Access be used to interact with other clients, such as Thunderbird, for example? What about email automation on a Mac? I know there is no Access for Mac, but what about Excel email automation in Mac with clients other than outlook...

This is the Delete Record code. I created this using the wizard in Access: Private Sub DeleteRole_Click() On Error GoTo Err_DeleteRole_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 Exit_DeleteRole_Click...

I tried the new code and removed my original event from the Delete Button. Now when I delete a TA2 record, the flag remains Yes. Something doesn't work.

Actually, the original code works even if TA2 is not the last entry. I added TA2 first and updated the form - flag switched to Yes. I added TA second and updated the form - flag remains Yes (as it should). I deleted TA2 and updated the form - flag switches to No. So it seems to be working. Why...

Sorry for the monolog... This is now working: Dim rs As dao.Recordset Me.Requery Set rs = Me.RecordsetClone rs.MoveFirst Do While rs.EOF = False If rs![RoleIDFK] = 3 Then Me.Parent.CourseHasTA2 = "Yes" Else Me.Parent.CourseHasTA2 = "No" End If rs.MoveNext Loop rs.Close Set rs =...

I had to make a couple of minor changes (including a typo in the field name), but now it's working, partially. It changes the field in the parent form to Yes, but if I delete the record, it doesn't change it back to No. I tried adding an Else clause, but it didn't help: Private Sub...

I changed ("fkRoleID") to [fkRoleID] but now I get a runtime error 3625: Item not found in this collection.

I get the following compile error: "Type-declaration character does not match declared data type." "rs!" is highlighted in the code. Is there supposed to be a space between rs! and ("fkRoleID")? The VBA editor in Access 2010 deletes the space even if I try to add it. Dim rs as dao.recordset...

Thank you for your reply. I have a form and subform. The form is linked to tblCourses and the subform to the junction table, with CourseID (tblCourses) as the Link Master and fkCourseID (junction table) as the Link Child. Roles, including TA2, are assigned using a combo box in the subform. I...

Thank you for your answer, Rank Am. It is helpful, and I will try what you suggested. The root of the problem is definitely normalization. Let me try to explain: The database is used to store instructional staff and course information, and the data is used to generate contracts. Instructional...

I posted this in a couple other places but haven't been able to resolve it. I am not sure if I need an update query, VBA code, or a combination of both. I use a form (linked to tblCourses) and a subform (linked to the junction table tblCoursePeopleRoles). I am trying to update the field...

I got at least part of question 1 from above. I based the form on tblCourseSections, so I am actually seeing the Section, not the Course. That's the easy part. I then created a subfrom linked to tblCourseSectionPeopleRoles, where I am able to assign people to specific roles for that Section...

Ok, I think I made a lot of progress. I am attaching a copy of the database with all the aforementioned forms. Everything seems to be working, but there are some new questions: 1. Is it possible to create a form with subforms and/or subsubforms that lists a Course Section at the top, then only...

Thanks for the explanation. I am making slow but steady progress here. Thanks for hanging in there...