I have a Make Table qry that builds a table called
Evaluation Table. I want to be able to copy this table
in the same database and change the name via a Macro. I
would like to have the table named the same thing as the
current Evaluation Id. Basically I want to have the user
Either input the name at the time of the Copy/SaveAs or
(even better) have the user lookup the name that they
want to SaveAs from the EvaluationID Table.
I realize that this is "spreadsheet-thinking" and it is
is something that I want to use temporarily. Very
temporarily. Each evaluation is sent to an evaluator and
that evaluator enters data into their evaluation database
and then they send that table back to the Database
Administrator. Then we run a few update queries and
append queries to place the data into the appropriate
Response Table, Survey Table etc. Then we will delete
the "spreadsheet/Evaluation Table" in the primary
database once we pull the data
from there and put them back into the database.
To sum up - I want to use a form to allow the user to
copy a table and enter the new name (via a lookup or type
it in) Thanks in advance.
matt
|
Similar Threads
