Excel VBA database query fails using ADO.

[gmahlert]

Hello,

I'm having a problem with an Excel VBA lookup query using ADO.

Hopefully I've missed something obvious to someone with more database experience.
I built this ADO class myself, but I have only a little database experience gained by trail and error.

My MS Access .accdb supplier database contains several firms which begin with the word steel.
When I query Steel% I get nothing back, but if I query Steel%Stock% it works perfectly.

A user form generates the filter from user input boxes and then submits the query to the ADO class.

I have used debug.print to watch the sFilter being generated and the result is Steel%


The query is done by an ADO class which uses SQL Like
this is the code used to call the class method

Please Login or Register  to view this content.

This is the code in the class method

Please Login or Register  to view this content.

[JosephP]

are you certain there is nothing (eg leading space) before the 'Steel' in the name?

[gmahlert]

I double checked the sFilter result to be sure. There are no leading characters. I even tried using trim(sFilter) to be sure. The result is the same.

[JosephP]

I meant in the data, not in the filter criteria

[JosephP]

does it work if you use %Steel% instead for instance?

[gmahlert]

I found the problem. I had a logic error using ubound to get a rowcount. The problem is solved.