DoCmd.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.

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
 
Since you will be doing this one at a time, and since you can link an Excel
(or other) spreadsheet to Access the exact same way that you link an Access
table, consider the following. Move your Excel spreadsheet (one-at-a-time)
to a specific location in the file system. Link to that file. Do your update
queries (or more likely append queries) to get the data consolidated into a
single structure within Access. Close the table/query/fprm that's linked to
the spreadsheet and delete that spreadsheet. Move the next spreadsheet (with
the same name) into that file location. Run the queries ... ad nauseum.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top