VBA-SQL Server connection problem...

[SamT]

You posted the problem.
I made suggestions.
You asked a question.
I answered the question.
I have no new information regarding your problem, therefore, I have no new suggestions.

[Samo]

Hi,

I have solved the problem by setting sql_string="string" , and now if you look atthe photos I attached earlier it can explain why it worked, but nowno debug at the step "rs.Open Sql, conn" as it went through this step, rather the debug happens at the step"If Not rs.EOF Then" and the error is attached, can you help please? i am not able to figure out what the problem is?

Thanks
Samo

VBA-ERROS1.PNG