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()

    1 answer 1

    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.

    • Yes, as it turned out, it is really impossible. - Jofsey