Query Make Table Name from Form

[Antonette]

I have eight text boxes from which I filter data on records on a form. I
want to make a table using a Make Table Query with the Name of the Table
being the contents from Text Box 1 and Text Box 8.

Does anyone know if and how this can be done without using VBA?

Thanks in Advance

Antonette

 

[John Spencer]

I know of no way to do this without using VBA to build the query string.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[John W. Vinson]

I have eight text boxes from which I filter data on records on a form. I
want to make a table using a Make Table Query with the Name of the Table
being the contents from Text Box 1 and Text Box 8.

Does anyone know if and how this can be done without using VBA?

Thanks in Advance

Antonette

Not that I can think of!

In addition, MakeTable queries are very rarely needed; MakeTable queries which
let the user create any arbitrary tablename sound like an absolutely DREADFUL
idea which will lead to unmanagable clutter of your database structure! What
is the context? Why do you feel that you need a tool to create tables (other
than the database window)?

If you're assuming that you must create a new table to filter data, or produce
forms, exports, or reports on filtered data - revise your assumption; you can
do this with a Select Query much more easily.