Search results

Nevermind, I got it working now. Thanks for the help!

Thanks for your reply. I tried to apply this method to my listboxes, but it would still only add the last selection in the list. This is the code I used: For Each varItem In Me.List8.ItemsSelected strPosition = Me.List8.ItemData(varItem) strCourses = Me.List4.Value strSQL = "INSERT INTO...

Hello, I have a form with two listboxes, one which holds the names of positions and another that holds courses. Each of these is based on a parent table. I have a PositionCoursestbl which stores what courses are required for each position. In my form, the user selects at least one position to...

Hello, I have a form with two listboxes, one which holds the names of positions and another that holds courses. Each of these is based on a parent table. I have a PositionCoursestbl which stores what courses are required for each position. In my form, the user selects at least one position to...

I removed the enforce referential integrity on the two relationships between the three tables, picked one item from each list and ran it. it worked, but it inserted "strItem" and "strLocation" into the Position and Courses Required for Position fields, respectively. The reason the error was...

It's saying "Microsoft Access can't append all records in the append query" and it says "...and it didn't add 1 record(s) due to the table due to key violations"

I have a Positions table and a Courses table between the PositionsCoursestbl, so I don't know if normalization is the problem. There are two list boxes on my form, one showing the data from the Positions table and one from the Courses table. What I'd like to do is have the user select the...

I'm using the following code to insert data into two fields (Position and Courses for Position) into a table (PositionCoursestbl) from two list boxes. However, when I make my selection from the listboxes and run the code, nothing happens Here's the code: For Each varItem In...

That's perfect, thank you!

Hello, How can I check if no items in a listbox have been checked? Thanks, David

I'm just trying to compare the values of a field on two different subforms (see below). Basically, all i want to do is let the user know which courses they have left to complete. The two subforms are running off of seperate queries. In the database I have a positions table, a positioncourses...

Just a note... In the procedure i have:Select Courses" & "From Forms!Staff_Training!CourseCompletedforPosition_Query_Subform but when I posted in here it came up:Select Courses" & "From Forms!Staff_Training!CourseCompletedforPosition_Qu ery_Subform sorry!

I tried it in the OnCurrent event in the subform, but i get a 2450 error on this line: Set RS = Forms!Staff_Training!CoursesCompletedforPosition_Query_subform.Form!Courses.Recordset It can't find the 'Staff_Training' main form, so I realized my syntax must be way off. So I googled around and...

I'm not sure of another way to do it. I was hoping the trigger would be when the main form's record was updated. It's not a calculation, just checking two recordsets to see if they match or not and outputting "Yes" or "No". Before I entered this into the textbox's control...

Thanks for letting me know Correct. Is there anything you can suggest in this situation to get the event to fire? I've tried in the BeforeUpdate as well but still no results

Sorry - how do I do that? The code is stored in the text box's afterupdate event

I have an event that won't fire. It's in an unbound text box in a subform that's supposed to compare the recordset in that subform with the recordset in another subform. However, when I run the form the textox is blank. *Also, I tried running breakpoints but still nothing happens Dim RS As...

Sorry, I'm still pretty new to this stuff! There is a positions table, a positioncourses table (which lists positions and the relevant courses to each one), a courses table, an employee training table (listing the employee's name, the courses they've completed, and the date it's been...

I've tried to, but the way i've structured it I don't think a query works. There is a positions table, a positioncourses table (which lists positions and the relevant courses to each one), a courses table, an employee training table (listing the employee's name, the courses they've completed...

Thanks for the tip! This is the code I used in the text box at the query level: =Format(DCount("*","PositionCourses Query","[PositionCourses Query.Courses]<>[Courses] and [PositionCourses Query.Position]<>[Position]")) However nothing came up. So I tried this in the AfterUpdate event in...