Recent content by joseph1234

I use an array becasue the data stored in is temporary..anyway I resolved the problem :D :D I just made my own In() function. Now in query I have WHERE (((isIn([Tab].[field]))=1)); yeaa :>

Thanks for your quick reply. This is one dimensin array of Integers. Every time I add new element into my array I use: ReDim Preserve ar(cnt) ar(cnt) = newValue cnt= cnt+ 1 I have no idea how to chagne it into horizontal version. If this wouldn't work do you have an idea how to replace...

Hello everybody. It's my first post :) I have a function which returns an array: Dim myArray(5) Public Function getMyArray() getMyArray = myArray End Function And now I'd like to do some query..something like this Select * From MyTable where MyTable.id IN (getMyArray()); When I use it...