copying and pasting

  • Thread starter Thread starter dj brian keith
  • Start date Start date
D

dj brian keith

i have a large database of music and recently converted
everything over to office xp. i was previously running
only access 97. after all the conversions and patches,
some new records i added scattered (seemingly at random)
throughout the database. i'm trying to use copy and paste
to put them back where they belong (to add new records),
and it keeps returning them to their random places in the
database. any ideas on how to get the cut and paste to
remain permanent?
 
What do you mean by "random places in the database"? If you are looking for
the records to be in a certain order in the table, don't. The tables hold
the data. Use queries or other sorting methods to order it.
 
It's a database of all the music I own, and I have it in the order that I purchased it. I just like keeping it in order by CD. When I entered new CD's, then exited, the records were placed throughout the database. I tried to cut and paste everything back to where it belongs, and it returned to wherever they were placed.
 
I still don't understand what you mean by "throughout the database". As I
stated, if you are simply speaking of the order the items are in, a table is
NOT designed to do that.

--
Wayne Morgan
MS Access MVP


dj brian keith said:
It's a database of all the music I own, and I have it in the order that I
Click to expand...
purchased it. I just like keeping it in order by CD. When I entered new
CD's, then exited, the records were placed throughout the database. I tried
to cut and paste everything back to where it belongs, and it returned to
wherever they were placed.
 
It's a database of all the music I own, and I have it in the order that I purchased it. I just like keeping it in order by CD. When I entered new CD's, then exited, the records were placed throughout the database. I tried to cut and paste everything back to where it belongs, and it returned to wherever they were placed.
Click to expand...

You're making the assumption that the records in a table have a
predictable order.

THEY DON'T.

A table HAS NO ORDER. It's an unsorted "bag" full of data; new records
will be put wherever there is room on the disk. There is no guarantee
that the most recently added record is the last record in the table;
it will be sometimes, but it could be the first or any other record.

If you want to see the records displayed in the order that the CD's
were purchased you must - NO OPTION! - have a field in the table
specifying that order (such as a PurchaseDate field or a sequential
Autonumber); you can create a Query sorting the table by that field,
and use this Query as the recordsource for your forms and reports.
 
Thank you! That's exactly what I'm doing. Why didn't I
think of it? Thanks again!
-----Original Message-----
Click to expand...
in the order that I purchased it. I just like keeping it
in order by CD. When I entered new CD's, then exited, the
records were placed throughout the database. I tried to
cut and paste everything back to where it belongs, and it
returned to wherever they were placed.
 
Back
Top