Search results for query: *

I've got fairly large app, with a back end database of about 500Mb. When I run any form none of the dlookup fields fill in and the "calculating" message appears on the status bar and just stays there. If I click on one of the dlookup fields it fills in right away. If I click on Windows Start...

Excellent, thanks so much. David

Thanks, I'll have a look for into on the .Filter index stuff. But further, can you confirm that Seek cannot be used? Thanks, David

Thanks for the info. I actually have the .Filter method working but I wanted to use .Seek It's a bit hard to find info on this but I'm under the impression that seeks are much faster against large tables - that indexes are used. I'm not sure about .Filter - does it use indexes? Thanks, David

I'll skip the part about gaining access to the data - assuming it's in a recordset. Dim strYr as String Dim strMth as String Do Until rs.EOF rs.Edit strYr = Left(rs!Expires,4) strMth = Right(rs!Expires,2) Select Case strMth Case "01" strDate = strMth &...

You bet: Dim cnnx as New ADODB.Connection Dim tblB as ADODB.Recordset Set tblB = New ADODB.Recordset cnnx.Provider = "sqloledb" cnnx.Properties("Data Source").value = "LocalServer" cnnx.Properties("Initial Catalog").value = "DataDBSQL&quot...

I've converted an MDB Data database to SQL 2000 and I'm accessing the data with an ADP. With the original Code MDB to Data MDB I could use Seek against the data mdb by opening a reference to the data mdb. Can I use Seek against the SQL 2000 tables? I can't figure out how to do this. I'm sure...