Hi all !
What I have:
In a BE database I use a temporary table to store some data.
Of course, for different filters that data will be different.
Keep in mind, please, that the table structure is not changed. Only data.
In a FE database I have
- A make table query based to the temporary table from BE. This is a simple query which simple transfer the temporary table from the BE to FE
- 2 command buttons: cmdStore_1 and cmdStore_2
What I wish:
- To run once my BE (with a filter) => to obtain a set of data in the temporary table then, to return to FE and press cmdStore_1 in order to run my query and to create Table_1.
- To run again the BE (with a new filter) => I obtain a new set of data in the temporary table then, to return (again) to FE and press cmdStore_2 this time in order to create Table_2.
So the question is:
How to pass the variable TableName to my (single) Make-Table query in order to obtain different tables.
Of course that can be easy managed using SQL in VBA.
But I prefer to use a "really" query because my poor skill in SQL don't allow me to easy change the SQL if needed (for code maintenance).
Thank you !