move record from 1 table to another table

[Jason Frazer]

how can i move info from 1 table to another?
I have a table with a form. The table and the form are
called customer. I want to move selected records to
an "old customer" table. How can I do this?

Thanks for help!

Jason

 

[Andrew Smith]

Don't bother - just add another field to the table that indicates that the
customer is an "old customer".

 

[Rick Brandt]

how can i move info from 1 table to another?
I have a table with a form. The table and the form are
called customer. I want to move selected records to
an "old customer" table. How can I do this?

Thanks for help!

Run an append query to copy the record to the [old customer] table and then a
delete query to remove it from [customer].

Or you could just add a field called [Obsolete] and just "mark" the customers as
old without any additional table needed.

 

[Jason Frazer]

Thanks for your advice.
How can i format the form to ignore those records with the
old customer box checked?

Thanks for your help

Jason

 

[Jason Frazer]

Thanks for your advice.
How can i format the form to ignore those records with the
old customer box checked?

Thanks for your help

Jason

-----Original Message-----

how can i move info from 1 table to another?
I have a table with a form. The table and the form are
called customer. I want to move selected records to
an "old customer" table. How can I do this?

Thanks for help!

Run an append query to copy the record to the [old customer] table and then a
delete query to remove it from [customer].

Or you could just add a field called [Obsolete] and just "mark" the customers as
old without any additional table needed.


.

 

[Betsy]

In the design view of the form, open the form's property window. Go to the
Record Source property on the Data tab. Click the elipsis button at the
right side of the Record Source property box. This will open a design
screen just like a query design screen. Add all of the fields you need for
the form. In the place an expression in the criteria row of the "obsolete"
field that filters out those records.

HTH- Betsy W.

Thanks for your advice.
How can i format the form to ignore those records with the
old customer box checked?

Thanks for your help

Jason

-----Original Message-----

how can i move info from 1 table to another?
I have a table with a form. The table and the form are
called customer. I want to move selected records to
an "old customer" table. How can I do this?

Thanks for help!

Run an append query to copy the record to the [old customer] table and then a
delete query to remove it from [customer].

Or you could just add a field called [Obsolete] and just "mark" the customers as
old without any additional table needed.


.

 

[Allen Browne]

Andrew and Rick's suggestion that a boolean field to "mark" the record as
obsolete is the best idea, particularly if you have related data you don't
wish to lose. Use a query to hide the obsolete records. The query can be the
RecordSource for your form.

If you want to cut the record from the interface and paste into another
table:
1. Click in the record to cut.
2. Choose Select Record from the Edit menu.
3. Choose Edit | Cut (or Ctrl+X).
4. Switch to the target table, new row (bottom).
5. Choose Paste Append from the Edit menu.

If you want to move a record programatically, that consists of an append
followed by a delete. Details in article:
Archive: Move records to another table
at:
http://allenbrowne.com/ser-37.html