vb 2147217900(80040e14) 不可识别字段

来源：百度知道 编辑：UC知道 时间：2024/05/15 14:27:59
哪的错呢 真是了。。。

lsql = ""
lsql = lsql & "Insert into"
lsql = lsql & " T_日报"
lsql = lsql & " ("
lsql = lsql & "T_日报.日付"
lsql = lsql & " ,T_日报.时间"
lsql = lsql & " ,T_日报.场所"
lsql = lsql & " ,T_日报.名前"
lsql = lsql & " ,T_日报.内容"
lsql = lsql & " )"
lsql = lsql & " values"
lsql = lsql & " ("
lsql = lsql & " #"
lsql = lsql & TxtDate.Text
lsql = lsql & "#"
lsql = lsql & " ,#"
lsql = lsql & TxtTime.Text
lsql = lsql & "#"
lsql = lsql & " ,"""
lsql = lsql & TxtAdress.Text
lsql = lsql & """"
lsql = lsql & " ,"""
lsql = lsql & ComName.Text<

（lsql = lsql & """"）很有问题是不是应该改成"'",在所有string类型的数据前面都要加上"'",楼主还忽略个问题。如果你要给的字符串中有(")这个符号，建议用chr（32）来替代，比如你需要这样写的话(& """ &)可以换成& chr（32）&