Invalid Argument

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Assuming that txtitemdescription and txtitemid are either controls on the
form in whose module the code is running, or are variables in the module you
should concatenate their values into the string expression. Text data should
be delimited with quotes, so if the description is a text data type and the
itemid a number data type the code would be:

DoCmd.RunSQL ("UPDATE tblinventory set itemdesc = """ & txtitemdescription
& """ WHERE itemid = " & txtitemid)

Ken Sheridan
Stafford, England
 
Back
Top