"Make-Table" Table name?

[CumbrianCanary]

I have a make-table query, which works fine. Is it possible for the user to be prompted for the name the table should be saved as? In the query the users is prompted for an input by [enter parameter here] but this doesn’t seem to work in the properties section in the query under “Destination Table”. Is what I am trying to do possible?

I have searched the forums but couldn’t find anything to help me.

Thanks in advance

CC

 

[FoFa]

Well, if you look at a MAKE Table query it appears as such:
SELECT Table1.TstID, Table1.TestCol1 INTO Table2
FROM Table1;
So in theroy you could change the SQL property behind the query, or just define a temp query def to do the same thing only using your table name instead.
But would not this create a bunch of table in the long run that are hard to maintain and clutter up your DB?

 

[CumbrianCanary]

I am still a little unsure how this will open up a prompt for the user to enter the name of the table being generated.

Yes you are right, it could create a number of tables. The user has their own front end so it would be their copy that would have the extra tables, not all users. This is something that a number of the users have requested.

Thanks
CC

 

[FoFa]

It would not "open up a prompt", queries don't work like that (for a table anyway). You would have to handle this in a form/vba.