If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Invalid Argument Error with Append Query
We've been getting an Invalid Argument error whenever we try to run an append
query. We have not had this problem in the past. We have just installed the SR-1/1a patch(es), and the DB size is only 4MB. I've tried an INSERT INTO VALUES() statement as well as the standard SQL text that comes with the query. We're out of ideas and would appreciate any help you can give us. Thanks! |
#2
|
|||
|
|||
Invalid Argument Error with Append Query
On Feb 13, 4:45 pm, stenz wrote:
We've been getting an Invalid Argument error whenever we try to run an append query. We have not had this problem in the past. We have just installed the SR-1/1a patch(es), and the DB size is only 4MB. I've tried an INSERT INTO VALUES() statement as well as the standard SQL text that comes with the query. We're out of ideas and would appreciate any help you can give us. Thanks! Hi - 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 |
#3
|
|||
|
|||
Invalid Argument Error with Append Query
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. " wrote: On Feb 13, 4:45 pm, stenz wrote: We've been getting an Invalid Argument error whenever we try to run an append query. We have not had this problem in the past. We have just installed the SR-1/1a patch(es), and the DB size is only 4MB. I've tried an INSERT INTO VALUES() statement as well as the standard SQL text that comes with the query. We're out of ideas and would appreciate any help you can give us. Thanks! Hi - 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 |
#4
|
|||
|
|||
Invalid Argument Error with Append Query
On Feb 14, 12:59 pm, stenz wrote:
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. " wrote: On Feb 13, 4:45 pm, stenz wrote: We've been getting an Invalid Argument error whenever we try to run an append query. We have not had this problem in the past. We have just installed the SR-1/1a patch(es), and the DB size is only 4MB. I've tried an INSERT INTO VALUES() statement as well as the standard SQL text that comes with the query. We're out of ideas and would appreciate any help you can give us. Thanks! Hi - 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 - Hi Stenz - I wish I had an easy answer for you - maybe some of the other experts on this board do - but the underlying purpose of a form is to enter data into a table. Normally a form is created off a certain table and the data is stored in the underlying table whenever it is entered into the form. So, it is a little weird that you would need an append query, which I assume is called on some event of the form, to enter data into a table. One issue I can see off the bat is your field [date]. The term "date" is a reserved term in Access. It would be better to call the field "CallDate" or something else. Also, if you think it's the memo field, make sure the table receiving the data input from the form is also set as a memo field. Hope ya figure it out. Diane |
Thread Tools | |
Display Modes | |
|
|