Sorting - Dumb question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We copy data from a spreadsheet provided by a customer and paste into a
subform within Access.

The issues are that data is being moved.?!..??

Dumb Question: If a user sorts on the subform, does Access automatically
sort all data within the records. - No chance it moves some fileds and not
others?
 
You should not copy/paste into Access from Excel, particularly a form. You
are asking for trouble and will undoubtedly create problems.
Use the TransferSpreadsheet Action or Method to copy the data from the
spreadsheet into your table.
 
I'm not sure if you're asking the right question. Are you talking
about FIELDS, or RECORDS? Access will initially put the data records
in whatever order you feed it, so the order you paste it into your
subform is the order it's going to keep unless it's sorted later on.

Not knowing what your subform does, I can't give a completely valid
answer. It's possible the person who designed it also added code to
sort the data.

Aside from that, you should follow Klaatu's advice.
 
aMack said:
We copy data from a spreadsheet provided by a customer and paste into
a subform within Access.

The issues are that data is being moved.?!..??

Dumb Question: If a user sorts on the subform, does Access
automatically sort all data within the records. - No chance it moves
some fileds and not others?
Click to expand...

Unlike Excel, Access always sorts records, not just columns. So if the
records in your subform are sorted, the sort will never move (sort) some
fields and not others.

What do you mean by "data is being moved"? I don't know if the current
sort order will be preserved when you copy/paste into Excel or not; I
would have thought so, but I haven't tried it.
 
Back
Top