append query error

[jedder18]

Running an append query.
It works when I have existing date in the table and append.
When I add a new record and try to append to another table, it is not working.
Giving me
type conversion failure
table key violations
lock violations
validation rule violations

This is alot of violations for an append query.

After stop running macro get this error

cannot find the 'l' you entered into the expression


I have no clue which expression or where
have checked all the table properties, form properties, query stuff, etc.:banghead:

Please give me some clues.....

 

[jedder18]

forgot to state

I'm using Access 2007
Windows 7

 

[jdraw]

Well post the sql for the query.
Do some google/M$oft research on each of these

type conversion failure
table key violations
lock violations
validation rule violations

Start here
http://www.access-programmers.co.uk/forums/showthread.php?t=223418

 

[jedder18]

INSERT INTO QuestionResponses ( [Question#], Question, ProgramId, [OutcomeID#] )
SELECT QuestionList.[Question#], QuestionList.Question, QuestionList.[ProgramID#], QuestionList.[OutcomeID#]
FROM QuestionList
WHERE (((QuestionList.[ProgramID#])=[Enter Program ID]));

 

[accessAnswer]

TO solve this error " cannot find the 'l' you entered into the expression"

Check whether table you are inserting INTO exists
2. Check whether table you are inserting FROM exists
3. Check whether ALL fields you insert from Exist (maybe spelling mistakes in names?)
4. Check whether ALL fields you insert in exist (maybe spelling mistakes in names?)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
visit msaccess2010.com for more help/ tutorials and debugging with MS Access