[AccessD] Array as source for query

Gustav Brock Gustav at cactus.dk
Fri Jan 19 12:39:55 CST 2007


Hi Drew

That might be doable, but wouldn't it be faster/simpler to write the array to a temp table and then use that as the source in the query?

/gustav

>>> DWUTKA at marlow.com 19-01-2007 16:12:22 >>>
Not by itself, but you can feed it into a query using a custom function, but
you still need an actual table as the recordsource.

Drew

-----Original Message-----
From: Kaup, Chester [mailto:Chester_Kaup at kindermorgan.com] 
Sent: Thursday, January 18, 2007 9:56 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Array as source for query

I think I know the answer but in VBA can an array be used as the source
data for a query instead of a table? If so how? Thanks.

 

Chester Kaup





More information about the AccessD mailing list