how make table name in make-table query an input?

  • Thread starter Thread starter Ian Elliott
  • Start date Start date
I

Ian Elliott

Thanks for any help.
I have a simple query that I want to change the table name for every time I
run it. I could do in the detail view of the query, but is it possible to
make like an input, like I do with a field by putting it in brackets? '[input
name here!]'
Thanks again.
 
Ian

Why?

You've described "how" you want to solve a business need, but nothing about
what that need is. If we had a more specific description of what problem is
being solved, we might be able to offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thanks for any help.
I have a simple query that I want to change the table name for every time I
run it. I could do in the detail view of the query, but is it possible to
make like an input, like I do with a field by putting it in brackets? '[input
name here!]'
Thanks again.
Click to expand...

WHY!!!?

MakeTable queries are very rarely needed.
Prompting the user for a tablename is a GUARANTEED way to clutter your
database with a lot of misnamed, misremembered, redundant tables.

Step back a bit. How are these tables being used? What are you doing with them
that cannot be done with a Parameter Query on your permanent stored tables?

To answer your question though, you can't. Paramters let you select values for
criteria or calculated fields, but not for the target table name. You'ld need
to construct the INSERT INTO query in VBA code to do this.
 
Thanks for any help.
I have a simple query that I want to change the table name for every timeI
run it. I could do in the detail view of the query, but is it possible to
make like an input, like I do with a field by putting it in brackets? '[input
name here!]'
Thanks again.
Click to expand...

Why do you have several tables with the same structure? Why not just
have _one_ table and include a column in which you add the "Group
name" for the records? Then you can just write one simple parameter
query and return any group you want.
 
Back
Top