Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recordset Searches
I have created a connection using a DSN and then Opened a recordset.
The queries is running fine, but I have lost the ability to .FINDFIRST or ..FINDNEXT What else can I use? I have written a loop to test for my condition, but it is not running nearly as fast when i was able to .FINDXXX Any thoughts? Thank you, Jim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recordset Searches
What kind of cursor are you using?
-- Tim Williams Palo Alto, CA "James McDowell" wrote in message ... I have created a connection using a DSN and then Opened a recordset. The queries is running fine, but I have lost the ability to .FINDFIRST or .FINDNEXT What else can I use? I have written a loop to test for my condition, but it is not running nearly as fast when i was able to .FINDXXX Any thoughts? Thank you, Jim |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recordset Searches
Can you elaborate on what you mean by lost the ability to .FINDFIRST? Do
you get an error message? Does nothing happen? Can you provide more of your code and show what line the error occurs on (if you are getting an error message)? Paul D "James McDowell" wrote in message ... : I have created a connection using a DSN and then Opened a recordset. : : The queries is running fine, but I have lost the ability to .FINDFIRST or : .FINDNEXT : : What else can I use? I have written a loop to test for my condition, but it : is not running nearly as fast when i was able to .FINDXXX : : Any thoughts? : : Thank you, : Jim |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recordset Searches
Set SALES_rcd = conSQl.OpenRecordset(Sales_sql, dbOpenSnapshot)
With SALES_rcd myfind = "LOT = '" & ActiveCell.Value & "'" Debug.Print .RecordCount .FindFirst myfind End With I get a Run Time error message 3251 that says "Operation is not supported for this type of Object" "PaulD" wrote: Can you elaborate on what you mean by lost the ability to .FINDFIRST? Do you get an error message? Does nothing happen? Can you provide more of your code and show what line the error occurs on (if you are getting an error message)? Paul D "James McDowell" wrote in message ... : I have created a connection using a DSN and then Opened a recordset. : : The queries is running fine, but I have lost the ability to .FINDFIRST or : .FINDNEXT : : What else can I use? I have written a loop to test for my condition, but it : is not running nearly as fast when i was able to .FINDXXX : : Any thoughts? : : Thank you, : Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup with two searches | Excel Discussion (Misc queries) | |||
Getting valid web searches and avoiding sites that contaminate web searches | New Users to Excel | |||
Searches | Excel Worksheet Functions | |||
Type recordset/recordset? | Excel Programming | |||
VBA and file searches | Excel Programming |