SQL problems using ADO in vba

Perhaps this

Please Login or Register  to view this content.

otherwise I think you need to provide more detail as to what is happening. If you are simply not getting any records, it would seem the criteria are wrong.

Did you test the version that I posted?

Print your final SQL string to the console, look for anything that looks wrong, and then try running that SQL string in the database itself. That will help narrow down if it is the specific SQL string or something else.

Also expanding on xlnitwit's point, I find that it is best to enclose table and field names in square brackets regardless. Belt and braces, it's easy to do and can avoid potential headaches in the future.

What's the error?

I don't know what the error was, the code was not executed.
The error handler that I inserted before the command was called.

There's no error handler in the code you posted.

If you did have an error handler, what happens if you remove/comment it out?

Do you then get an error message?