Access中也一样update tablename set fieldname=replace(fieldname,'aaa','bbbb')VBA中dim a as string dim b as string currentproject.connection.execute "update tablename set fieldname=replace(fieldname,'" & a & "','" & b & "')"为什么说是函数未定义呢?? 因为你根本没有使用ACCESS环境,只不过调用了MDB文件而已http://access911.net/index.asp?board=4&recordid=77FAB51E14DC http://access911.net/index.asp?board=4&recordid=79FAB51E12DC
dim b as string
currentproject.connection.execute "update tablename set fieldname=replace(fieldname,'" & a & "','" & b & "')"为什么说是函数未定义呢??
因为你根本没有使用ACCESS环境,只不过调用了MDB文件而已http://access911.net/index.asp?board=4&recordid=77FAB51E14DC
http://access911.net/index.asp?board=4&recordid=79FAB51E12DC