Search results

Thank you i tried no..

Thank you.. I really didn't have the solution of the Query in mind.. Problem with the specific database was beyond my capabilities as to think of good structure, also as to fill tbl_attendances by a form whenever i typed sessions because i hadn't used append (insert into) queries bf. But it is...

Hi all, i wish i knew what is wrong with the query supposed i need returning records Main form called Fr_ScheduleEditor, subform Frmsub_CourseLastRecords. Subform has a single table as rowsourse, managed by SELECT Tbl_CourseSessions.courseID, Tbl_CourseSessions.instructorID...

And also, code you suggested is working as charm...!

Thank you for viewing and replying about structure. Though thinking of tracking the attendees would you suggest to have in the new table TblAthleteSessions the field attendance? And if so why not keeping Tbl_CourseAttendance and have FK to Tbl_athletes.athleteID FK to...

no it worked as charm. it put athletes all right away. Thanks for your efforts i ll try later back here on the problems .. Have to go Sorry my English is not so good. Problem is not solved i meant it didnt ask something about t athletes when i run query as you said. Still command doesn't work...

I did that, it asked parameters parent.courseID, i entered 36 for my previus tries courseID and produced i buch or records in table Attendance

I dont know how to output that maybe this you mean? INSERT INTO Tbl_CourseAttendances (courseID, CourseDate, athleteID) SELECT Parent.[courseID], #2022/06/20#, athleteID FROM Tbl_CourseSessions INNER JOIN Tbl_CourseAthletes ON Tbl_CourseSessions.courseID = Tbl_CourseAthletes.courseID WHERE...

My DB

Put s How do i do it. do you mean immediate window?

I cannot correct it now with Private Sub cmdAllAthletes_Click() Dim s1 As String s1 = "" s1 = s1 & "INSERT INTO Tbl_CourseAttendances " s1 = s1 & "(courseID, CourseDate, athleteID) " s1 = s1 & " SELECT Parent.[courseID], " & Format(Parent.[CourseDate], "\#yyyy\/mm\/dd\#") & "," s1 = s1 & "...

Saw that so i corrected it with Private Sub cmdAllAthletes_Click() Dim s1 As String s1 = "" s1 = s1 & "INSERT INTO Tbl_CourseAttendances " s1 = s1 & "(courseID, CourseDate, athleteID) " s1 = s1 & " SELECT Parent.[courseID], " & Format(Parent.[CourseDate], "\#yyyy\/mm\/dd\#") ''''error & "," s1...

With SHANEMAC51 way no error just no records inserted immediate window INSERT INTO Tbl_CourseAttendances (courseID, CourseDate, athleteID) SELECT athleteID, 36, #2022/06/12# FROM Tbl_CourseSessions INNER JOIN Tbl_CourseAthletes ON Tbl_CourseSessions.courseID = Tbl_CourseAthletes.courseID WHERE...

sorry but it didn't work as above, and considering field order i changed it as: Private Sub cmdAllAthletes_Click() Dim s1 As String s1 = "" s1 = s1 & "INSERT INTO Tbl_CourseAttendances " s1 = s1 & "(courseID, CourseDate, athleteID) " s1 = s1 & " SELECT Parent.[courseID], " &...

Thank you.. I shall try that

In order to make easier for planning course sessions i needed to have seperate time field in Tbl_CourseSession. I did as you advised and removed unnecessary extra ID (autonumber keys) from my tables since i have those composite keys in those tables. i have done so to eliminate dublicates. Also...

After what to suggested ..what i managed doing was a mess I tried with Debug.Print strSQL after: Private Sub cmdAllAthletes_Click() Dim strSQL As String strSQL = "INSERT INTO Tbl_CourseAttendances " & _ "(courseID,CourseDate,athleteID) " & _ "SELECT " &...

I shall try all of suggestions thank you

Sincerely i dont know how to accomplish your suggestions i am struggling reading pieces of information about it. Thats why i need help