大家好我是送分的kofkim~送分从来不含糊~~~~简单的数据库访问~~~~```问题进来看看~~~~~~~`

[kofkim]

Private Sub Command1_Click()
Set rs = New ADODB.Recordset
valup = Form1.a + Form1.b
valdown = Form1.a - Form1.b
rs.Open "select * from 码头 where 码头长度（米）between valup and valdown ", cn, adOpenDynamic, adLockOptimistic
Set DataGrid1.DataSource = rs
Form2.Refresh
End Sub

结果程序不认识SQL语句中的valup 和valdown的值

救命啊~~~~~~~~~~~~~~~~~~``

[vbkiller]

改正为：
rs.Open "select * from 码头 where '码头长度（米）' between valup and valdown ", cn, adOpenDynamic, adLockOptimistic

此外，你的form1.a与form1.b这样赋值对吗？

[kofkim]

我在form1中public 了a 和b

能赋值给valup和valdown

问题就是select中就认识不到了~

[X_Team_wx]

rs.Open "select * from 码头 where '码头长度（米）' between +valup and
+valdown ", cn, adOpenDynamic, adLockOptimistic

[xmubeta]

变量怎么可以直接写在字符串里呢？ 你要把valup 和 valdown 分出来写，用& 符合连接。

[kofkim]

我自己给出正确答案吧~
rs.Open "select * from 码头 where 码头长度（米） between "&valup&" and
"&valdown&" ", cn, adOpenDynamic, adLockOptimistic

[gameboy999]

rs.Open "select * from 码头 where 码头长度（米）between " + valup+ " and " + valdown, cn, adOpenDynamic, adLockOptimistic

是变量当然不能加到字符串中咯。
楼上两个都是对的。，