Using the non-scalar VBA function in a SQL query

Question

I have a VBA function that returns a table

Public Function GetNames() As ADODB.Recordset

Is it possible to use it in SQL queries?

For example, for a regular sample: SELECT * FROM GetNames()

msi msi 11k eleven sixteen · Accepted Answer · 2012-11-21T15:02:40

I do not think that this is possible in Access. But you can put the result of a function into a table, and then choose from it.

1 answer 1