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
|
|||
|
|||
Sorting - Dumb question
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? -- A MACKENZIE, CMA, MBA |
#2
|
|||
|
|||
Sorting - Dumb question
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. "aMack" wrote: 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? -- A MACKENZIE, CMA, MBA |
#3
|
|||
|
|||
Sorting - Dumb question
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 wrote: 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? -- A MACKENZIE, CMA, MBA |
#4
|
|||
|
|||
Sorting - Dumb question
"aMack" wrote in message
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? 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. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
Thread Tools | |
Display Modes | |
|
|