Hello all,
Going back to post 103517
The error came back again. below is the error and breakdown of the table and the SQL.
Any help would be appreciated.
Thank You
Jim Wagner
The Error
Microsoft Access set 0 field(s) to Null due to a type conversion failure, and it didn't add 1 record(s) to the table due to key violations, 0 record(s) due to lock violations, and 0 record(s) due to validation rule violations.
Do you want to run the action query anyway? ........
Button caption:
MOVE Record to Tracking History - deletes it from your vacant table
Embedded Macro:
Macro
mcro_AppendVacantRecordToTracking
SaveObject: Form, Vacancy Input
OpenQuery: qry_AppendVacancyRecordToTrackingComplete
Append query: Appends Vacancies table record to Tracking complete table based on
vacantID = [Forms]![Vacancy Input].[ID]
SQL for qry_AppendVacancyRecordToTrackingComplete
INSERT INTO TrackingComplete ( vacantID, ActionReq, PositionNumber, PSPosition, AFFILIATEID, DeptCode, VacantName, VacancyJobTitle, [JOB CODE], VacantStateAreaOrg, VacantStateAreaOrg2, VacantStateAreaOrg3, VacantStateFTE, VacantStateFTE2, VacantStateFTE3, VACSTATESALARY, VACSTATESALARY2, VACSTATESALARY3, VACLOCALSALARY, VACLOCALSALARY2, VACLOCALSALARY3, VacantLocalFTE, VacantLocalFTE2, VacantLocalFTE3, VacantLocalAreaOrg, VacantLocalAreaOrg2, VacantLocalAreaOrg3, FilledEfftDate, FilledName, VacantSalaryPlanning, FilledComment, FilledStateAreaOrg, FilledStateAreaOrg2, FilledStateAreaOrg3, FilledStateFTE, FilledStateFTE2, FilledStateFTE3, FILLEDSTATESALARY, FILLEDSTATESALARY2, FILLEDSTATESALARY3, FILLEDLOCALSALARY, FILLEDLOCALSALARY2, FILLEDLOCALSALARY3, FILLEDLOCALFTE, FILLEDLOCALFTE2, FILLEDLOCALFTE3, FilledLocalAreaOrg, FilledLocalAreaOrg2, FilledLocalAreaOrg3, VacantComment, student, FilledNewSalary, SalarySavings, Classification, [Date of Action], status, Fte )
SELECT Vacancies.ID, Vacancies.ACTION, Vacancies.[OLD POS], Vacancies.[NEW POS], Vacancies.AFFILIATEID, Vacancies.DEPT, Vacancies.VACATEDBY, Vacancies.[VAC JOB TITLE], Vacancies.[JOB CODE], Vacancies.VACSTATEACCT, Vacancies.VACSTATEACCT2, Vacancies.VACSTATEACCT3, Vacancies.VACSTATEFTE, Vacancies.VACSTATEFTE2, Vacancies.VACSTATEFTE3, Vacancies.VACSTATESALARY, Vacancies.VACSTATESALARY2, Vacancies.VACSTATESALARY3, Vacancies.VACLOCALSALARY, Vacancies.VACLOCALSALARY2, Vacancies.VACLOCALSALARY3, Vacancies.VACLOCALFTE, Vacancies.VACLOCALFTE2, Vacancies.VACLOCALFTE3, Vacancies.VACLOCALACCT, Vacancies.VACLOCALACCT2, Vacancies.VACLOCALACCT3, Vacancies.[DATE FILLED], Vacancies.FILLEDBY, [VACSTATESALARY]+[VACSTATESALARY2]+[VACSTATESALARY3] AS VacantSalaryPlanning, Vacancies.[FILLED COMMENTS], Vacancies.FILLEDSTATEACCT, Vacancies.FILLEDSTATEACCT2, Vacancies.FILLEDSTATEACCT3, Vacancies.FILLEDSTATEFTE, Vacancies.FILLEDSTATEFTE2, Vacancies.FILLEDSTATEFTE3, Vacancies.FILLEDSTATESALARY, Vacancies.FILLEDSTATESALARY2, Vacancies.FILLEDSTATESALARY3, Vacancies.FILLEDLOCALSALARY, Vacancies.FILLEDLOCALSALARY2, Vacancies.FILLEDLOCALSALARY3, Vacancies.FILLEDLOCALFTE, Vacancies.FILLEDLOCALFTE2, Vacancies.FILLEDLOCALFTE3, Vacancies.FILLEDLOCALACCT, Vacancies.FILLEDLOCALACCT2, Vacancies.FILLEDLOCALACCT3, Vacancies.COMMENT, Vacancies.student, [FILLEDSTATESALARY]+[FILLEDSTATESALARY2]+[FILLEDSTATESALARY3] AS FilledNewSalary, Vacancies.SalarySavings, Vacancies.Classification, Vacancies.[Date of Action], Vacancies.status, Vacancies.Fte
FROM Vacancies
WHERE (((Vacancies.ID)=[Forms]![Vacancy Input].[ID]));
Tables
Vacancies table
ID = AutoNumber
Field Size = Long Integer
New Values = Increment
Indexed = Yes (No Duplicates)
TrackingComplete table
ID = AutoNumber
Field Size = Long Integer
New Values = Increment
Indexed = Yes (No Duplicates)
vacantID = Number
Field Size = Long Integer
Decimal Places = Auto
Required = No
Indexed = Yes (No Duplicates)
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar