Re: User Define Array Data Type - Subscript out of range

PatK wrote:
Thanks...I am going to make these changes. I will let you know how it goes. It may solve a problem I am having now, that I did not before, mainly, on the ..open, it is expecting a select statement (or somesuch error I have not seen thus far), and I see you have one (altho now I am scratching my head as to why the .open worked before, and not now).

That's a good question...ADO is usually pretty intelligent that way. For future reference, where I added "adCmdText", you could add "adCmdTable" or "adCmdTableDirect" and see if that fixes the problem. (Just don't ask me what the difference between the two is...I've forgotten at this point, though the names themselves certainly imply a thing or two.)

There is not a lot of data to load into the table...about 40 entries, but I am all for coding things efficiently, as I leverage my past work, in the future.

Oh, and J was for a debug loop I was using later, that I exclude from the code....LOL (sorry about that!).

Hehehe...been there, done that. I'm sure if I went through all my code, I'd find LOTS of unused stuff floating around. :)

Patk

Thanks again!

NP


Rob
.