我是用dao来访问数据库的,下面是我的一段代码:
Dim TableName As String
Dim tantouhao As String
Dim database As dao.database
Dim rs As dao.Recordset
dbname = Month(dat) & "0" & Day(dat) & ".mdb"
TableName="1"
tantouhao="101"
Set database = DBEngine.Workspaces(0).OpenDatabase(App.Path & "\" & Year(Now) & "\" + dbname)
Set rs = database.OpenRecordset("select * from " & TableName & " where 分站号=" & tantouhao)
出现了问题,系统提示说:too few parameters expected 1.
究竟是OpenRecordset语句中哪里出了错,请指教。
Dim TableName As String
Dim tantouhao As String
Dim database As dao.database
Dim rs As dao.Recordset
dbname = Month(dat) & "0" & Day(dat) & ".mdb"
TableName="1"
tantouhao="101"
Set database = DBEngine.Workspaces(0).OpenDatabase(App.Path & "\" & Year(Now) & "\" + dbname)
Set rs = database.OpenRecordset("select * from " & TableName & " where 分站号=" & tantouhao)
出现了问题,系统提示说:too few parameters expected 1.
究竟是OpenRecordset语句中哪里出了错,请指教。
如果是字符类型,应该要单引号的
是不是还有需要一些参数?
Set rs = database.OpenRecordset("select * from " & TableName )
加了之后就不行,系统提示说参数少,但上句就可以,怎回事呢?
同时我提示:tantouhao是整型类型。
在线等!!!!!