S
sound_trax
Guest
Hi
Does anyone know how I can change the table that a query looks at whilst the program is running. At the minute there are 20 posssible tables that I may want to delete a record from. I could have 20 delete queries and that would work but this mean everytime a new user joins the business I would have to create a lot of queries and tables for them. I have an invisible text box on a form and that is the name of the table I want to reference for the query.
Does anyone know how this can be done, I don't mind using VB at all.
Thanks in advance
Does anyone know how I can change the table that a query looks at whilst the program is running. At the minute there are 20 posssible tables that I may want to delete a record from. I could have 20 delete queries and that would work but this mean everytime a new user joins the business I would have to create a lot of queries and tables for them. I have an invisible text box on a form and that is the name of the table I want to reference for the query.
Does anyone know how this can be done, I don't mind using VB at all.
Thanks in advance