All:
I've been trying to figure out what the issue is with a query of mine that is not updateable.
I have a training database and my query is pulling from 2 tables. One table is the records table with employee number, name, course, department, date completed, etc. The parameters of Name, Department and Course are linked to combo boxes in my opening form. The second table is the schedule. This has the month, year and courses assigned. The courses on this table are relational to the courses in the records table. The month parameter is from a combo box in the opening form.
The goal is to be able to put the month in along with the other parameters and update the records based on things like department and month of assignment. If I take out the schedule parameters, it works, but when I include the schedule table it becomes non-updateable.
Below is the code for the query
SELECT [04-RecordEntryMaster].[EE Number], [04-RecordEntryMaster].[EE Name], [04-RecordEntryMaster].[Course Name], [04-RecordEntryMaster].[Department Cost Center], [04-RecordEntryMaster].Frequency, [04-RecordEntryMaster].[Last Date], [04-RecordEntryMaster].[Next Date], [04-RecordEntryMaster].Pass, [04-RecordEntryMaster].Status, [07-ScheduleMaster].ScheduleMonth, [07-ScheduleMaster].Type
FROM [07-ScheduleMaster] INNER JOIN [04-RecordEntryMaster] ON [07-ScheduleMaster].ScheduleCourse.Value = [04-RecordEntryMaster].[Course Name]
WHERE ((([04-RecordEntryMaster].[EE Name]) Like "*" & [Forms]![frmRecordEntry]![cboName] & "*") AND (([04-RecordEntryMaster].[Course Name]) Like "*" & [Forms]![frmRecordEntry]![cboCourse] & "*") AND (([04-RecordEntryMaster].[Department Cost Center]) Like "*" & [Forms]![frmRecordEntry]![cboDepartment] & "*") AND (([07-ScheduleMaster].ScheduleMonth) Like "*" & [Forms]![frmRecordEntry]![cboMonth] & "*") AND (([07-ScheduleMaster].Type)="Training"));
Regards
I've been trying to figure out what the issue is with a query of mine that is not updateable.
I have a training database and my query is pulling from 2 tables. One table is the records table with employee number, name, course, department, date completed, etc. The parameters of Name, Department and Course are linked to combo boxes in my opening form. The second table is the schedule. This has the month, year and courses assigned. The courses on this table are relational to the courses in the records table. The month parameter is from a combo box in the opening form.
The goal is to be able to put the month in along with the other parameters and update the records based on things like department and month of assignment. If I take out the schedule parameters, it works, but when I include the schedule table it becomes non-updateable.
Below is the code for the query
SELECT [04-RecordEntryMaster].[EE Number], [04-RecordEntryMaster].[EE Name], [04-RecordEntryMaster].[Course Name], [04-RecordEntryMaster].[Department Cost Center], [04-RecordEntryMaster].Frequency, [04-RecordEntryMaster].[Last Date], [04-RecordEntryMaster].[Next Date], [04-RecordEntryMaster].Pass, [04-RecordEntryMaster].Status, [07-ScheduleMaster].ScheduleMonth, [07-ScheduleMaster].Type
FROM [07-ScheduleMaster] INNER JOIN [04-RecordEntryMaster] ON [07-ScheduleMaster].ScheduleCourse.Value = [04-RecordEntryMaster].[Course Name]
WHERE ((([04-RecordEntryMaster].[EE Name]) Like "*" & [Forms]![frmRecordEntry]![cboName] & "*") AND (([04-RecordEntryMaster].[Course Name]) Like "*" & [Forms]![frmRecordEntry]![cboCourse] & "*") AND (([04-RecordEntryMaster].[Department Cost Center]) Like "*" & [Forms]![frmRecordEntry]![cboDepartment] & "*") AND (([07-ScheduleMaster].ScheduleMonth) Like "*" & [Forms]![frmRecordEntry]![cboMonth] & "*") AND (([07-ScheduleMaster].Type)="Training"));
Regards