I have a ADO control on a form. It's connected to a Access table. Now ADO control's Recordsource, we can type a table name or a SQL statement. If I type a sql statement like
Select *from table where ID = myValue
But it doesn't work, I tried many different ways to put "my Value" or "& myvalue &", nothing worked. Can anyone help? myValue is dynamic and from input.
Thanks.
Question for ADO control(VB6)
本帖於 2004-02-06 15:24:48 時間, 由普通用戶 old-cotton 編輯
所有跟帖:
•
Question for ADO control(VB6)
-mma2001-
♀
(312 bytes)
()
01/15/2004 postreply
23:56:00