CopyObject

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

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.

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
 
Yes, this can be done, but it is a VERY BAD IDEA. You should not be storing
each evaluation in a separate table. This is "spreadsheet-thinking" and not
"database-thinking". All of your evaluations should be stored in the same
table with a field holding the EvaluationID to differentiate the records
from one evaluation from another. You can separate them out using either
forms, reports or queries.
 
I could not agree more. However, all the evaluations are
stored in the same table. The "spreadsheet-thinking" 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" once we pull the data
from there and put them back into the database.

Thanks for your input. And again, I realize that this is
counter intuitive but I think my idea will work
especially since it's temporary. Thanks.

matt

-----Original Message-----
Yes, this can be done, but it is a VERY BAD IDEA. You should not be storing
each evaluation in a separate table. This
Click to expand...
is "spreadsheet-thinking" and not
 
Back
Top