move record from 1 table to another table

  • Thread starter Thread starter Jason Frazer
  • Start date Start date
J

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
 
Don't bother - just add another field to the table that indicates that the
customer is an "old customer".
 
Jason Frazer said:
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!
Click to expand...

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.
 
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
 
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-----
Jason Frazer said:
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!
Click to expand...

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.


.
Click to expand...
 
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.

Jason Frazer said:
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-----
Jason Frazer said:
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!
Click to expand...

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.


.
Click to expand...
Click to expand...
 
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
 
Back
Top