vba array type missmatch

**Jollyfrog** · 11-10-2010, 06:38 AM

Hi,

im trying to extract values from an array that i have filled with an sql statement, only problem is i get a type missmatch error?
it could be that the array is very large! maybe 400 entries

Please Login or Register  to view this content.

idtsd is defined as a variant

thanks

**DonkeyOte** · 11-10-2010, 06:53 AM

It would help if we could see how idtsd is itself defined ... also do you have members within the array that contain apostrophe's ?

**Jollyfrog** · 11-10-2010, 07:00 AM

members did contail apostrophies, so i altered the code, however it must have been erroring before it got to them,

Please Login or Register  to view this content.

the arrar is populated on line 30

thanks

Jonathan

**DonkeyOte** · 11-10-2010, 08:53 AM

Sorry for delay.

Without wanting to get too involved in optimisation at this stage - I've not a database to test against presently - but when you step through the code using the Locals Window how is idtsd defined ?

Assuming idtsd definition is ok (ie an appropriate Array) then does the SQL generate as you expect, ie add a debug prior to the execution line and review in Immediate Window:

Please Login or Register  to view this content.

**Jollyfrog** · 11-10-2010, 10:33 AM

Ok,

so i pasted in a whole bunch of debug lines and it turns out one of my if statements was out,
triggering on if EOF = true not false.. so the array never populated and errored out!

problem solved :D

thanks for your time and help