Run-Time Error When SQL Runs

[mtilbury]

Hi I am trying to run the following code. When I Step-through the code it gets to the 'End Function' I get the following message 'Run-time error - Object doesn't support this property or method'


I have similar code that is working fine. It is just this particular one where the error is?

When i copy the Debug.Print SQL_STRING in to SQL the SQL part of the code works.

Am I missing something on the VBA side?

Please Login or Register  to view this content.

[kasan]

Edit: Sorry, misread real question.
Tested your code on my connection - works fine.

[mtilbury]

Would you know why I get this error? I just copied the exact code above and i still get the error. 'Run-time error 438 - Object doesn't support this property or method'

It runs the code fine, but when I look at this by Stepping-Into the code the error appears once I have stepped through the code and the current step is on 'End Function' (highlighted yellow)?

So appears something might be wrong with the way it is trying to exit on End Function?

[kasan]

Have no idea, really. Did you try to run your code under Sub () (not function)?

[xlnitwit]

How are you calling this function?

[mtilbury]

I Kasan

I have fixed the error. For some unknown reason the code didnt like the Function. I just moved this code into the main part of my coding on the userform and it works.

[mtilbury]

Hi xlnitwit I call all my function like this Application.Run Module1.ELTTables It works for all the others, just this one.

[xlnitwit]

That is not the same function name?

[mtilbury]

Sorry, I know I was just giving an example of the structure I use. It call the Function fine and runs through it. Its was just the Exiting of the Function

[xlnitwit]

My assumption is that something was wrong at the calling end since the function itself runs properly. Unless we can see the actual caller it's hard to verify though.

[mtilbury]

Agh it was that. So silly. I wrote Rum instead of RUN.

[xlnitwit]

I assume you know that Run takes a routine name so its argument should be in quotes

Please Login or Register  to view this content.