Hello,
I don't know if it's possible but here goes. I have a function that list's all the tables in it's database. I want to take that list and turn it into a record set so I can add it to a veriable.
"ie. table1, table2, table."
"rs.recordset.next"
Or something like that where it will assign the first table name to a value and then when done move onto the next and so on untill its gone through all of the tables.
The easiest way I could think of was to have it all in a table and call the table as a record set and cycle through them but I don't know how to call the function I have in a make table query or SQL statement.
Any help would be nice and if there is a better way then please let me know.
Thank you.
I don't know if it's possible but here goes. I have a function that list's all the tables in it's database. I want to take that list and turn it into a record set so I can add it to a veriable.
"ie. table1, table2, table."
"rs.recordset.next"
Or something like that where it will assign the first table name to a value and then when done move onto the next and so on untill its gone through all of the tables.
The easiest way I could think of was to have it all in a table and call the table as a record set and cycle through them but I don't know how to call the function I have in a make table query or SQL statement.
Any help would be nice and if there is a better way then please let me know.
Thank you.