CopyObject (1 Viewer)

[dkirk02]

Hello all! I am using the CopyObject method in the event procedure of a command button to make a copy of the underlying table. I'd like to be able to date stamp the new Tblname with the current date. Effectively, every day that work is assigned, the assigned case load for that day would be saved in the current dB, as, for ex:
"Work Assigned 01/25/02" and each day a new tbl would be created. Any thoughts?
Thanks in advance for any help!

Deeta

 

[Rich]

Why is it neccessary to create a new table every day?

 

[dkirk02]

We are using this process as a quality control check and would need to keep atleast 1-2 weeks worth of work assigned in the dB. There may be need in the subsequent weeks to go back and report off of the data. We'd like to be able to report on work assigned to a person on any given day of the two week period.

 

[Pat Hartman]

This will be much easier to manage if you simply add rows to a table. Keep the AssignedDate in the record and you can use queries to extract any or all date ranges from the table for reporting or populating forms.