Yeah, sorry, didn't think this one thru completely.
It's a standard append query to take info from a form and append to a table.
We're not using anything fancy, just a couple combo boxes, a memo field, and
adding the date automatically. The table fields are all text except for
Date/Time and Memo for the memo field.
We think the problem lies in the memo field. If we type more than 127
characters, we get the error. We've also tried a regular text box, but get
the same error after 127 characters.
BUT, none of our other append queries are effected. So we are stumped.
The append SQL is this:
INSERT INTO Calls ( ProjectID, Client, Comments, [Date], Admin, Category )
SELECT [FORMS]![Calls]![cmbProjectID] AS Expr1, [FORMS]![Calls]![cmbClient]
AS Expr2, [FORMS]![Calls]![txtComments] AS Expr3, Date() AS Expr4,
[FORMS]![Calls]![cmbAdmin] AS Expr5, [FORMS]![Calls]![cmbCategory] AS Expr6;
I've also tried a VALUES() SQL, but got the same error:
INSERT INTO Calls ( ProjectID, Client, Comments, [Date], Admin, Category )
VALUES ([FORMS]![Calls]![cmbProjectID], [FORMS]![Calls]![cmbClient],
[FORMS]![Calls]![txtComments], Date(),[FORMS]![Calls]![cmbAdmin],
[FORMS]![Calls]![cmbCategory])"
Any help we can get would be very much appreciated.
Can you provide some more info? Like the exact sql of the append query
as well as the field types of the table you are appending into?
Sounds like a syntax error in your append query...
Diane- Hide quoted text -
- Show quoted text -