資料庫指令詢問 資料庫, 變數

bakise68

有一資料庫XXX.MDB內有a,b,c,d,e,f,g..等資料表.
如何用變數達成資料表選用,例如:
rs.Open "Select * from  a where Time between " + Chr(35) + Str(DTP1.Value) + Chr(35) + " And " + Chr(35) + Str(DTP2.Value) + Chr(35), Cnn, adOpenDynamic, adLockOptimistic
架設我的變數是TT,我把語法改為如下,但無法執行...
dim tt as string
TT=a
rs.Open "Select * from  TT where Time between " + Chr(35) + Str(DTP1.Value) + Chr(35) + " And " + Chr(35) + Str(DTP2.Value) + Chr(35), Cnn, adOpenDynamic, adLockOptimistic

因為有很多資料表需要用到變數來處理,求高手幫忙指點.

denniswave

你的 TT 用引號括起來了，變成文字，不是變數
rs.Open "Select * from " & TT & " where Time between " + Chr(35) + Str(DTP1.Value) + Chr(35) + " And " + Chr(35) + Str(DTP2.Value) + Chr(35), Cnn, adOpenDynamic, adLockOptimistic