Microsoft Access, Continuous Form View, Copy Records and Column Order
Posted on 2009-02-08
I have the following code in a form and the code is executed with a button:
Forms!SessionHistory.RecordSource = rstString
rstString is defined above this code. Everything works great. Except, if I do a "copy all records" and then paste the result in a document, the columns are out of order.
So, I switched to Datasheet view and lo and behold, the datasheet view was displaying them in the order that they were being pasted. So, I modifed the datasheet view to put them in the order I wanted. Then, I switched back to continuous form view, selected, copied and pasted and it still ended up the way it was before. As a side note, when I do the copy/paste thing in datasheet view, it now works as I want it.
Now, before all this, a long time ago (well, 8 years ago when I first wrote this database), the original rstString was ordered the way the records are actually showing up in the copy/paste scenario. But I changed that years ago.
So, how do I get the copy/paste stuff to display the columns in the order specified? I've saved both forms (the "parent" with the clickable button and the subform with the data). I've cursed, danced and prayed.