D
Dan Scates
I am using Access2000 and am getting "Invalid argument"
when inserting into a table with form variables. I have a
form that accepts a "description" field that is 130 chars
and when I run this query I get the above error:
INSERT INTO quote_details(partno,partdesc)
select forms!frmAddPart!txtPartno,forms!frmAddPart!
txtPartdesc;
The "partdesc" field is defined as 255 chars in the
quote_details table. By trial-and-error I determined that
127 is the max without getting the Invalid argument. Any
suggestions will be greatly appreciated.
when inserting into a table with form variables. I have a
form that accepts a "description" field that is 130 chars
and when I run this query I get the above error:
INSERT INTO quote_details(partno,partdesc)
select forms!frmAddPart!txtPartno,forms!frmAddPart!
txtPartdesc;
The "partdesc" field is defined as 255 chars in the
quote_details table. By trial-and-error I determined that
127 is the max without getting the Invalid argument. Any
suggestions will be greatly appreciated.