Previous Thread

6/15/2006 1:24:01 PM    Invalid Argument
I have a db that has begun to display an Invalid Argument error, when 
 
attempting to run an UPDATE statement.  I have looked at the data, thinking 
 
it may be an issue with a reserved character.  However, when testing other 
 
data, that have the same characters, the problem does not occur. 
 
Could this be record corruption, or does someone see a data issue, that I am 
 
missing? 
 
The data is: 
 
Standard Wireless Communications Kits (includes: 1 indoor with 15 inch 
 
antenna and 1 outdoor wireless modems with 20 foot antenna) 
 
the SQL is: 
 
DoCmd.RunSQL ("Update tblinventory set itemdesc = txtitemdescription where 
 
itemid = txtitemid;") 
 
Thanks, in advance. 
 
Sharkbyte