From: Klatuu on 3 Nov 2009 09:32 Nor have used ADO. Perhaps I wasn't clear enough. I did not mean to say that it is only ADO. "Dirk Goldgar" <dg(a)NOdataSPAMgnostics.com.invalid> wrote in message news:upqDlh8WKHA.3720(a)TK2MSFTNGP02.phx.gbl... > "Klatuu" <dahargis(a)verizon.net> wrote in message > news:%23lu5UG8WKHA.3696(a)TK2MSFTNGP02.phx.gbl... >> Use the FindFirst. You code is DAO code, but Seek is actually an ADO >> method. > > David, I don't think I would put it this way. Both the DAO and ADO > Recordset objects have a "Seek" method. They have slightly different > restrictions, though, related to the differences between DAO and ADO. As > you mentioned, the DAO Seek method can only be used with a table-type > recordset, while the ADO Seek method can only be used with a server-side > cursor *and* a command-type of adCmdTableDirect. (I got the ADO > information from the help file; I've never used the ADO Seek method.) > > -- > Dirk Goldgar, MS Access MVP > Access tips: www.datagnostics.com/tips.html > > (please reply to the newsgroup) >
First
|
Prev
|
Pages: 1 2 Prev: select value form combo box on a web page Next: Ms Access got an error and quit |