If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using for to append modified records to new table
I have a table with thousands of records. As these records are reviewed
additional fields are populated. As these fields are populated, I want them to append to a different table. How do I achieve this? |
#2
|
|||
|
|||
Using for to append modified records to new table
As these fields are populated, I want them to append to a different table.
Fields are not appended, only records. Why are you not using that table to start with? Explain a little bit more about your operation and someone might be able to suggest a better method. -- Build a little, test a little. "Bev" wrote: I have a table with thousands of records. As these records are reviewed additional fields are populated. As these fields are populated, I want them to append to a different table. How do I achieve this? |
#3
|
|||
|
|||
Using for to append modified records to new table
I am using it for all records. I only want append those records with
modifications to a new table "KARL DEWEY" wrote: As these fields are populated, I want them to append to a different table. Fields are not appended, only records. Why are you not using that table to start with? Explain a little bit more about your operation and someone might be able to suggest a better method. -- Build a little, test a little. "Bev" wrote: I have a table with thousands of records. As these records are reviewed additional fields are populated. As these fields are populated, I want them to append to a different table. How do I achieve this? |
#4
|
|||
|
|||
Using for to append modified records to new table
On Fri, 12 Feb 2010 10:07:01 -0800, Bev wrote:
I have a table with thousands of records. As these records are reviewed additional fields are populated. As these fields are populated, I want them to append to a different table. How do I achieve this? If you're using a Form to "populate" the additional fields (as you should be!!) you can use the AfterUpdate event of the form to either run an Append query to copy data from this table to the other one, or open a Recordset based on the second table and fill it from the form controls. But... why are you storing the same data redundantly in two different tables??? That's almost always a Very Bad Idea. -- John W. Vinson [MVP] |
#5
|
|||
|
|||
Using for to append modified records to new table
The source data gets replaced on a weekly basis. I need to save a historical
view of the data. "John W. Vinson" wrote: On Fri, 12 Feb 2010 10:07:01 -0800, Bev wrote: I have a table with thousands of records. As these records are reviewed additional fields are populated. As these fields are populated, I want them to append to a different table. How do I achieve this? If you're using a Form to "populate" the additional fields (as you should be!!) you can use the AfterUpdate event of the form to either run an Append query to copy data from this table to the other one, or open a Recordset based on the second table and fill it from the form controls. But... why are you storing the same data redundantly in two different tables??? That's almost always a Very Bad Idea. -- John W. Vinson [MVP] . |
Thread Tools | |
Display Modes | |
|
|