Search results

It is my mistake. Everthing is correct. There is no space and yes it is Me.AttendanceDuration. still same. I tried to attach but 2MB limit. It is a bit big file. more than 10 MB.

Thanks Ted, I did the following code Private Sub UPDATETEACHER_Click() Dim strSql As String strSql = "INSERT INTO tblTeachersAttendance (CoursesTakenByTeachers_ID, AttendanceDate, AttendanceDuration, AttendanceNote)" _ & "SELECT CoursesTakenByTeachers_ID SELECT CoursesTakenByTeachers_ID, #"...

Thanks for your relpy Ted. The problem is just there. Because The fields AttendanceDate, AttendanceDuration, AttendanceNote are not coming from where CoursesTakenByTeachers_ID comes. I have a form which user enters students and teacher attendance easily. In that form User needs to input data...

Hi everyone I am trying to insert several data into a table. (simply appending students and teacher attendance) I can do students but I have got problems with teacher attendance The following code works fine Private Sub UPDATETEACHER_Click() Dim strSql As String Dim strSql_2 As String...