In a form I have created a command button with the following code:
DoCmd.RunSQL "INSERT INTO TblIncentiveDetail (VenNumber,VendorName,IncentiveDescript,Criteria,GrowthIncent,DetailYear,IncentiveTotal) VALUES (VenNumber,VendorName,IncentiveDescript,Criteria,GrowthIncent,DetailYear,IncentiveTotal);"
The problem is that on some records it works great and on others it says "Invalid Arugment". I narrowed it down to the filed GrowthIncent. When I take it out of my code it works perfect. When I add GrowthIncent it doesn't work all the time. GrowthIncent is a memo field that holds text and numbers. Here is example:
10 - 14% Growth = .25% Rebate
15 - 19.00% Growth = 1% Rebate
20% + = 1.25% Rebate
Excludes 3M, BD, J&J, Drop Ships, Non-Stocks
Some similar text will go through but some won't. I don't even know what to check anymore.
Any help would be great!
Shannon
DoCmd.RunSQL "INSERT INTO TblIncentiveDetail (VenNumber,VendorName,IncentiveDescript,Criteria,GrowthIncent,DetailYear,IncentiveTotal) VALUES (VenNumber,VendorName,IncentiveDescript,Criteria,GrowthIncent,DetailYear,IncentiveTotal);"
The problem is that on some records it works great and on others it says "Invalid Arugment". I narrowed it down to the filed GrowthIncent. When I take it out of my code it works perfect. When I add GrowthIncent it doesn't work all the time. GrowthIncent is a memo field that holds text and numbers. Here is example:
10 - 14% Growth = .25% Rebate
15 - 19.00% Growth = 1% Rebate
20% + = 1.25% Rebate
Excludes 3M, BD, J&J, Drop Ships, Non-Stocks
Some similar text will go through but some won't. I don't even know what to check anymore.
Any help would be great!
Shannon